Summarize & Join
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I have a workflow where i summarize the result set to get the count and the output of the UNION is the expected desired result but i want to join my UNION output to my Main stream with the PROD ID and SUB PROD ID.
Please note the data set is huge and and have too many rows and columns
Any thoughts would be much appreciate attached the sample workflow..
- Labels:
- Common Use Cases
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @suby ,
Is the purpose of the flow to calculate row /column totals? If so, try using the attached Crew Macro.
Thanks,
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Michael,
Thanks for sharing and its not about calculating the row totals instead.
Before My union I've summarized the result set by PROD ID and SUB PROD ID and on my union Output i get the Desired result but i want to join my union output to my original source Data using the PROD ID and SUB PROD ID column.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @suby ,
In the Summarize tool, you have calculated 'COUNT DISTINCT', hence PROD ID and SUB PROD ID have been eliminated.
In your current output after the UNION tool, you CANNOT join it back to original source.
May I know what do you wish to accomplish by joining it back to source?
Please share a final expected output based on current scenario.
Thanks and Regards,
Shreyansh
