Numeric Data Type

[Anonymous]

Hi I have two tables.

Table A has ID, IDName  ( Both ID and IDNumber are Int datatype)

001,AAA

002,BBB

003,CCC

Table B has ID, Sum ( ID and Sum are String Data type)

001,1000

002,2000

003,3000

In my Script Load

i converted the  ID

Num#(ID) from Table B

but im not able to sort the SUM in the report.

[kenphamvn]

hi

With ID as above, you do not need convert to number for sorting

Please check Sort Property panel and make sure ID column on Top

Regards

An Pham

[shraddha_g]

You stated ID and Sum both are in String Format,then you will also have to do Num#(Sum) to convert it into Number Format.

[Anonymous]

An Pham, Thanks for the reply. I did that analysis didnt work for me.

[Anonymous]

TShraddha Thanks for the reply,

Ya i apply the Num#() to both the fields. But Sorting not working with sort function where sorting working with Alphabets of String.

[shraddha_g]

Can you share sample app?

Else provide Screenshots of what you have done in chart

[Chanty4u]

try in sort tab

match(id,'001','002','003')