Data360 Analyze

 View Only

  • 1.  Data Transformation

    Posted 05-19-2023 06:41

    Hi,

    I'm looking for a way to do the following data transformation within data360.

    I have an input data and I want to process it to have the following output:

    Input:

    Output:

    Appreciate any suggestions. Thank you!



    ------------------------------
    Dhinmar James Cayog
    Knowledge Community Shared Account
    ------------------------------


  • 2.  RE: Data Transformation
    Best Answer

    Posted 05-22-2023 06:03

    Hello,

    The solution I found is to use an aggregate node as follows:
    Grouping by 'id' field and using the "group.joinString" method on the "Color" field

    Kind regards

    Eugenio



    ------------------------------
    Eugenio Borrelli
    Assistant Data Analyst
    Linklaters
    London, UK
    ------------------------------



  • 3.  RE: Data Transformation

    Posted 05-23-2023 02:43

    This worked! Thanks a lot!



    ------------------------------
    Dhinmar James Cayog
    Knowledge Community Shared Account
    ------------------------------

    Original Message


  • 4.  RE: Data Transformation

    Employee
    Posted 05-31-2023 03:57

    This worked for me too:

     
    out1.id = fields.id
    out1.Color = group.joinStrings(fields.Color, False, ', ')


    ------------------------------
    Sam Darmo
    Precisely Software Inc.
    PEARL RIVER NY
    ------------------------------

    Original Message