Data360 Analyze

 View Only

  • 1.  How to concatenate rows into a single field?

    Employee
    Posted 12-03-2020 17:53

    I have an input with many rows, and I want output with single attribute with all input data concatenated together by comma separator.

    For eg below input:

    123

    456

    789

    To be output as single field as "123, 456, 789"

     

    How can I do that?

     

    Regards

    Avi



  • 2.  RE: How to concatenate rows into a single field?

    Employee
    Posted 12-04-2020 03:03

    You can use scripting in a Transform node:

     

     

     

    Attached files

    Concatenate_rows_into_list - 4 Dec 2020.lna

     



  • 3.  RE: How to concatenate rows into a single field?

    Employee
    Posted 12-06-2020 17:19

    Its working. Thanks a lot Adrian for the solution



  • 4.  RE: How to concatenate rows into a single field?

    Employee
    Posted 10-13-2021 16:15

    Hi,

    I'm trying to re-purpose the function using the Aggregate node to concatenate rows with Group By.  I clearly failed and need help.  Can someone please help?



  • 5.  RE: How to concatenate rows into a single field?

    Employee
    Posted 10-13-2021 17:05

    Looking through old posts, I found and got it working using the following

    out1.Result = group.joinStrings(in1.name)

    I don't understand the difference between Configure Fields vs Process Records.  Is there online documentation that explains it?  Thanks



  • 6.  RE: How to concatenate rows into a single field?

    Employee
    Posted 10-14-2021 02:46

    This is explained in the Help documentation for your system - see the 'Node help' > 'Aggregation and Transformation' > 'Transform' topic or the online Help documentation here:

    https://doc.infogixsaas.com/analyze/Default.htm#e-node-help/Aggregation_and_Transformation/transform.html

    Per the documentation, the ConfigureFields script is executed only once and this occurs before the first input record is read. The ProcessRecords script is then executed for each input record.