Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
An Pham, Thanks for the reply. I did that analysis didnt work for me.
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.
Can you share sample app?
Else provide Screenshots of what you have done in chart
try in sort tab
match(id,'001','002','003')