Data360 Analyze

 View Only

  • 1.  How to combine multiple rows based upon value in specific column

    Posted 11-04-2021 09:48

    Hi,

    How can I create the second table starting from the first one? So based upon a business term value, creating a column where in this example the text is split by a ','.

    Thanks!



  • 2.  RE: How to combine multiple rows based upon value in specific column

    Employee
    Posted 11-10-2021 05:56

    This should give you the results you want.

    The logic in the data flow sorts the data by the key field (BusinssTerm) and strips out any records with Null values. Then, in a Transform node, the key and value of the first record are stored. For all subsequent records, the current key value is compared with the previous record's key. If they are the same the new value is concatenated onto the value(s) stored for the previous key. If the current key value is different from the previous key value, the previous key and the concatenated value are output. For the final record, the last key and result are also output.

     

     

     

     

    Attached files

    Combine_Rows_Using_Key_Field - 10 Nov 2021.lna

     



  • 3.  RE: How to combine multiple rows based upon value in specific column

    Posted 11-10-2021 09:14

    Hi Adrian,

     

    Great! Thanks for the help; it works as expected.

     

    Kind Regards,

    Jonas