SOLVED
Merge two reports
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
sshivani
6 - Meteoroid
‎07-31-2020
12:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
I have 2 reports with different data and want to merge the reports. I can understand that with 'contains' formula we can get the result. However, for large data set contains formula will not be feasible. Please let me know if there is any other approach for the same.
Report 1:
Description |
ABC USA |
ABC France |
ABC CanadaLtd |
ABC Canada |
ABC Australia |
ABC Brazil |
Report 2:
Country |
USA |
Australia |
Canada |
Netherlands |
Output:
Country | Description |
USA | ABC USA |
Australia | ABC Australia |
Canada | ABC CanadaLtd |
Canada | ABC Canada |
Netherlands | NIL |
Regards,
Shikha
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
4 REPLIES 4
17 - Castor
‎07-31-2020
01:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @sshivani I mocked up a workflow that produces your output let me know what you think?
PhilippK
Alteryx Alumni (Retired)
‎07-31-2020
01:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @sshivani ,
please find my approach attached:
 
Is this the solution you were looking for?
Best regards
Phil
‎08-03-2020
02:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for your help.
Regards,
Shikha
‎08-03-2020
02:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for you help.
Regards,
Shikha
![](/skins/images/303A6AD65FCA043F1D2938424191616C/responsive_peak/images/icon_anonymous_message.png)