Comments

[evinothk]

Invoice Number	Amount
ABC1	$100

Invoice Number	Comments
ABC1	Storage
ABC1	Handling fee
ABC1	Other fee

I have two inputs where invoice number is common- How to concatenate by  Invoice and bring the comments in a single row? Like below

Invoice Number	Amount	Comments
ABC1	$100	Storage Handling Fee Other Fee

[JosephSerpis]

Hi @evinothk you can use the summarise tool to concantene a field I mocked up an approch. Let me know what you think?

[FlorianC]

In addition to what @JosephSerpis  proposed, if you are looking to match the exact example output, you can use a newline character as a separator in the summarize tool.

Example workflowSummarize tool configuration