13 Replies Latest reply: Jun 7, 2013 2:37 AM by Mani Kolli RSS

    Problem with long digit key column

    Mani Kolli

      Hi All,

       

      I am facing very strange issue.

       

      This is my Load Statement.

      Exp:

      Load     ExpRecID,

                     ExposureID,

                     BorrowerID;

      Select  ExpRecID, ExposureID,BorrowerID

      From     tblExposure;

       

      Here, ExpRecID is an autogenerated number in table and it contains 18 digits. The values of ExpRecID is 100000000075607570, 100000000075607571,100000000075607572 etc etc. After loading, initially the ExpRecID list box is not showing any values. After adding Number format ##################  (18), i can see the values but it is not showing all values. Actuallt ExpRecID and ExposureID are in 1 to 1 ratio.For each ExposureID, the corresponding ExpRecID exists. But the values are not coming properly in the dash board. I am using version 9.

       

      ExpRecID is the key column and i have to use it in further joins. Please guide me to solve this issue. I have tried Text(). evaluate() etc but no use.

       

       

       

       

      Attaching the required files now. Exp.csv is having the correct data.

       

      Message was edited by: ManiKolli