Summarize & Join

Question

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..

New Workflow2.yxmd

shreyanshrathod · Answer

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

suby · Answer

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.

MichaelSu · Answer

Hi @suby ,

Is the purpose of the flow to calculate row /column totals? If so, try using the attached Crew Macro.

Thanks,

Mike

CReW_AddTotalRowColumns.yxmc