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

Numeric Data Type

ramesh konda Nov 7, 2017 4:01 AM

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.

Re: Numeric Data Type

An Pham Nov 7, 2017 4:23 AM (in response to ramesh konda)
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

11-7-2017 16-18-36.jpg 16.3 K

11-7-2017 16-12-12.jpg 108.6 K
Like Show 0 Likes (0)

Actions
- Re: Numeric Data Type
  
  ramesh konda Nov 7, 2017 6:56 AM (in response to An Pham)
  
  An Pham, Thanks for the reply. I did that analysis didnt work for me.
  
  Like Show 0 Likes (0)
  
  Actions
Re: Numeric Data Type

Shraddha Gajare Nov 7, 2017 4:45 AM (in response to ramesh konda)

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.
Like Show 0 Likes (0)

Actions
- Re: Numeric Data Type
  
  ramesh konda Nov 7, 2017 6:57 AM (in response to Shraddha Gajare )
  
  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.
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: Numeric Data Type
    
    Shraddha Gajare Nov 7, 2017 7:00 AM (in response to ramesh konda)
    
    Can you share sample app?
    
    Else provide Screenshots of what you have done in chart
    
    Like Show 0 Likes (0)
    
    Actions
Re: Numeric Data Type

Chanty 4u Nov 7, 2017 7:03 AM (in response to ramesh konda)

try in sort tab

match(id,'001','002','003')
Like Show 0 Likes (0)

Actions

Go to original post