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 |
Hi @evinothk you can use the summarise tool to concantene a field I mocked up an approch. Let me know what you think?
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.