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.  Changing data types

    Employee
    Posted 12-13-2016 10:09

    I've brought in a fixed format file and many columns have leading zeros.  Some should be string and some should be converted to numeric format.  How can I selectively assign data types by column?



  • 2.  RE: Changing data types

    Employee
    Posted 12-13-2016 10:42

    Use the Data Analyzer node to look at the data.  On the 2nd pin of the Data Analyzer, on the far right, are lines of code that can be used to manipulate the data.

    Copy that code into a Transform node...

    Add " default emit * " as the LAST line of the code in the Transform node

    Then, remove any lines of code where you do NOT want the transformation performed, and you can also edit the transformations in any manner you wish.