Value coming from query is chaing in the Table view

[Former Member]

Hi experts,

I am new to VC and developing a basic model by using a BI query as a data service.

I have a field "Project Code" which can return value numeric or alpha numeric or Character.

for example

Project Code= 14000000000000002782007 or

ATROVASTATIN

When i am right clicking the query and doing the test query function its displaying correctly but when i am draging from the output port of this query and using a Table view to display the data the numeric values like in our example "14000000000000002782007" is displaying as 1.4e+23 its displaying the same value where ever i have some numeric value in the field.

But its displaying the Char value right "ATROVASTATIN" as it is.

In the table view the field which is getting this value is with Datatype Text.

How can i solve this problem.

Thanks and regards

Neel

[Former Member · Accepted solution]

Hi Neel,

Have a look at this link,

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/sizeof_key+values&