6 Replies Latest reply: Nov 7, 2017 7:03 AM by Chanty 4u RSS

    Numeric Data Type

    ramesh konda

      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.