5 Replies Latest reply: Mar 15, 2018 7:42 AM by Varun Prakash Paulraj RSS

    Some numbers formatted as string

    Varun Prakash Paulraj

      Hi Experts,

       

       

      I have an amount column in the database inthis i have some of the amounts formatted as string and i am getting a huge mismatch

       

      I have tried Num#() and *1 but nothing worked.

       

      Please suggest a workaround to fix this permanently in the load script.

       

       

      Capture.PNG