Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

MACRO - Any Suggestions?

suby
11 - Bolide


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.

 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Read-in-Multiple-Excel-Files-with-M...

 

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.

24 REPLIES 24
mceleavey
17 - Castor
17 - Castor

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.



Bulien

mceleavey
17 - Castor
17 - Castor

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.

 



Bulien

suby
11 - Bolide

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

 

 

mceleavey
17 - Castor
17 - Castor

Hey, no problem at all.

 

Next Friday is good for me. Send me a direct message with your email address, Timezone etc. and I'll send over an invite. 

 

M.



Bulien

suby
11 - Bolide

Many Thanks will do..

Labels