Hello Team,
I am trying to combine the different excel sheet data into 1 sheet. Request you to please help me in designing the flow.
Attached is a file for reference.
Thanks,
Solved! Go to Solution.
Hello @Learner09, try this. I have created a workflow with a help of macro.
I hope this helps!
Thanks!
Thank you so much @grazitti_sapna. It's working.
How did you build this small macro, I am very new in terms of implementing and designing macro in Alteryx flow.
Thanks
Mayank
@Learner09, you can start with this link- https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Standard-Macro... if you want to learn how to work with macros.
Or you can simply right-click on the macro that I created.
I hope this helps!
Thanks!
Thank you @grazitti_sapna. I have only one query what is the role of the below-mentioned file in the macro because the file data is all different.
@grazitti_sapna is that possible if you are able to send the file that is saved on the system - 'C:\Test Folder\File New. xlsx|||Sheet1'. It's really helpful for me to understand how this macro work.
@Learner09, it is just a random file I used you can put any random path in the text input tool. Macro is nothing but another workflow with a control parameter, outside the macro I am just passing a path that will be read inside the macro. But attaching the file below.
Thanks!
Hello @grazitti_sapna . Sorry for the multiple messages. For the last one, I designed the Macro on my own ( to learn better) and it works fine. The only challenge I faced now is macro front connector is missing, how I can enable this connector. Please help.