Data360 Analyze

Welcome to the Data360 Analyze community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 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: