Data Consolidation of excel workbooks using Alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 :)
Solved! Go to Solution.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs Thanks a ton ! I have just tweaked a bit and it worked thanks again for all your help and support
