Data Transformation - Feedback Rating

[hiteshnpwc]

Hello Everyone,

I am trying to transform the data in multiple sheets into one. Here we have the rating of each Training faculty in each sheet. I have created a workflow however when new training faculty are added to a new sheet they are not added to the output. Need your help to review my workflow and help me if I have missed anything. Attached are the Input data and Alteryx workflow.

Also, I need to eliminate the select record tool where I have placed manual row numbers to ignore while merging, however, if data is added it will give incorrect output.

[oneillp111]

@hiteshnpwc  can you include the macro?

[hiteshnpwc]

@oneillp111  Attached is the macro file

[oneillp111]

@hiteshnpwc , I just added a sheet to your file and the results went from 160 to 190, so it seems to work when new data is added

[oneillp111]

you could use a template for the columns you want to keep, then union it with the data and output common subset of fields

[asss3434]

feedback

[bagijuoramed]

xcs