Data Consolidation of excel workbooks using Alteryx

[vinayvnn]

Hello Community, 

I want to consolidate the files in a folder, where each file in the folder is having 2 or many sheets. However Country Tracker is a common sheet in all the excel workbooks. and these Country Trackers should consolidate to a output and rest all the sheets irrespective of sheet names it should consolidate to another output.

Please note that consolidation should only happen to the field which ever is present in the first file sample headers in Country tracker and other trackers are given below:

Country Tracker headers:

Client, Collection Period, Collection Status, Remarks, Notes

other trackers headers:

Client Name, Collection period, Period, Notes1, EMP name

any support will be much appreciated ! Thank you :) 

[OTrieger]

@vinayvnn  your post is not clear. 
Bear in mind that we do not see the data nor your folders, therefore write it in a clear way and share some details so we can understand what you are facing and what you would like to achieve.

[binu_acs · Accepted solution]

@vinayvnn you need to use batch macro for your use case. With batch macro first read all the sheet names, then filter out the Country Tracker sheet  and write to a different output file, the same way the other sheets can be consolidated into another file

[vinayvnn]

@binu_acs Thanks a ton ! I have just tweaked a bit and it worked thanks again for all your help and support