We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

How to concatenate rows into a single field?

Comments

5 comments

  • Avatar
    Adrian Williams

    You can use scripting in a Transform node:

     

     

     

    Attached files

    Concatenate_rows_into_list - 4 Dec 2020.lna

     

    0
    Comment actions Permalink
  • Avatar
    Avi

    Its working. Thanks a lot Adrian for the solution

    0
    Comment actions Permalink
  • Avatar
    William Pang

    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?

    0
    Comment actions Permalink
  • Avatar
    William Pang

    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

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    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.

    0
    Comment actions Permalink

Please sign in to leave a comment.