Data360 Analyze

 View Only

  • 1.  Unicode data can't change to double

    Employee
    Posted 03-24-2020 23:23

    I would like to change a field from unicode to double type. 

    Previous run is fine, but this problem occur after serveral runs.

    It's a comma values , e.g. 1,234,567.89 

    Thanks for helping.



  • 2.  RE: Unicode data can't change to double

    Employee
    Posted 03-25-2020 02:44

    Can you tell us which version of Analyze are you using? 

    I tried to reproduce the issue using a sample of data on my v.3.6.0 system and the Modify Fields node successfully converts the unicode values to double values. Can you provide us with a sample of the data that causes the issue for you (we just need the field with the unicode data).

     

    As an interim work around you could remove any commas from the field using a Transform node configured as follows: