Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data Consolidation of excel workbooks using Alteryx

vinayvnn
7 - Meteor

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 :) 

3 REPLIES 3
OTrieger
13 - Pulsar

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

binuacs
21 - Polaris

@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

image.png

 

vinayvnn
7 - Meteor

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

Labels
Top Solution Authors