Hi Experts,
I am new to Alteryx. I am working on a workflow where I have multiple mapping table centrally stored in an excel (e.g. one mapping in one tab). These mapping tables are similar in nature but with different numbers of columns, and I would like to process them with the same set of tasks and macro (e.g. run mapping1 first with the workflow, and then run mapping 2 with the same workflow, etc).
Instead of copying the same workflow multiple times, I would like to tap to everyone's expertise to make it more streamline. Appreciate your help.
thank you.
E.
Solved! Go to Solution.
Hi @E_Liang,
As it looks like you are comfortable in making a batch macro, that would be my recommendation for this task you are looking to complete.
If you convert the process you have shown below into a batch macro and as the control parameter pass through the sheet name and then update that within the Input tool.
You can then use this batch macro in a separate workflow and pass through all the sheet names you need to process.
I hope that helps.
Thanks
Joe
hi Joe,
Thank you for the valuable advice.
I have tried to package my original workflow as a batch macro. And since control parameter could not be place directly to an macro input, I have added a dynamic input. Also, I have tried created a separate workflow to call this batch macro, but it returns with an error in my dynamic input, not sure what I have done wrong. Appreciate your further assistant.
Thank you very much
E
Hi @E_Liang,
WIthin your batch macro you do not need to have the mapping workbook as a Macro Input.
You can have it as a standard tool and use the control parameter to update the part you need :-)
I hope that helps.
Joe
hi Joe,
Thank you very much for your advise. I am now able to get through.
Thank you.
Eric
Hi Eric,
Would you be able to attach your workflow or send a screenshot?
I'm facing the same problem but I can't seem to get it to work.
Kind regards,
Prav
Hey E_Liang
I am new to macros and have been trying to learn it. I have the same problem fo repeating the same process for multiple sheets of an excel file. Actually it is 50+. I have to create an alteryx workflow for each sheet. It would be great if you could explain your way, in a more detailed manner. I know you would be super busy, let me know if you get any time. I tried downloading your workflows and tried to understand it, but wasn't able to do so.
Hoping for a reply.
Cheers,
Rohit