what I'm trying to achieve is I have two excel files ( Two months Data) with two tabs with different schema and I want to combine all these into one single Dataset which can be done by creating the Nested macro mentioned in the post below by Andrew.
The solution By Andrewl combines the Data set when we run the workflow based on different schema with multiple tabs and Multiple sheets.
What I'm looking for is still I want to combine two files with different schema and I should be able to filter for specific worksheet in my main workflow and then do combine the data set on my main workflow say.
I'll leave this open for the community geeks to see if any one can provide a solution.
Solved! Go to Solution.
Hey @suby ,
glad I could help. Could you mark my first response as the solution? It will help others when they're searching the same things.
Thanks,
M.
Hi @suby ,
You can simply use the select tool to drop unwanted columns, but the data cleansing tool will dynamically drop those columns that are not related to those sheets.
As for a walkthrough of the macros and the workflow, I'm happy to do so but I have almost no free time.
I would recommend going through the interactive training sessions on Macros, you can find them here:
https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Macros
Also there are some good videos here:
https://community.alteryx.com/t5/Videos/Summer-Camp-Introduction-to-Macros/td-p/597252
https://community.alteryx.com/t5/Videos/Introduction-to-Building-Macros/td-p/139730
https://community.alteryx.com/t5/Videos/Build-Your-First-Batch-Macro/td-p/52900
I hope you find these helpful.
If you want to jump on a call for 30 minutes next week I'm happy to do so. I'm on UK time, so let me know when you have availability and I'll try and make some time for you.
M.
Hello,
Absolutely will do that and its been great working with you and Thank you so much for your time Very Much appreciated.
The reason I don't want to use the select tool is because we have more than 100 columns to deselect and its time consuming.
I will go through the Links you shared and that will give me a good start. I'm happy to join the call with you may be next Friday if you have time.
Many Thanks
Many Thanks will do..