Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions?
Ask here!
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
How can I repeat the below section by using it once for two different data input?
The input data structure follows different structure and the joined column name is different too.
Hi @wenyg,
If the data is structured differently, then you could use a directory tool and feed the file names into a batch macro (see explanation here). You would also have to feed the name of the field you want to join on into the macro (and use an action tool to update the join). Here's an example of what the inside of the macro would look like for the join:
If you only have to do these joins twice in the workflow, it might not be worth the time and effort to make a batch macro though.
