Data Consolidation of excel workbooks using Alteryx

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

Data Investigation

Accepted answers

binu_acs

@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

Country_Tracker_04092024.yxzp

All comments

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

Country_Tracker_04092024.yxzp

vinayvnn

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703