Comments
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
evinothk
7 - Meteor
‎12-14-2021
02:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Labels:
- Labels:
- Expression
2 REPLIES 2
17 - Castor
‎12-14-2021
02:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @evinothk you can use the summarise tool to concantene a field I mocked up an approch. Let me know what you think?
Alteryx
‎12-15-2021
09:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 workflow
Summarize tool configuration
Florian Carrier
Strategic Solution Consultant
Alteryx
Strategic Solution Consultant
Alteryx
