Dynamic Input with a macro

[Inactive User]

Hello,
Hello, I have the following problem. I would like to create a macro. The problem here is that I have two input data which I would like to dynamically combine with each other. In the filename, there is an identifier that is identical. I would like to change this identifier for each iteration with the help of the macro. But I am so confused with this environment, that I stayed away from it :D 

             

Addition to that every Output should have the ending of the second table.... 
Can you help?

[binu_acs · Accepted solution]

@Inactive User Batch macro can address your issue. The below post has the batch macro, you can use that for your use case

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Ultimate-Input-DataFlow-Errors/td-p/1092306

[Inactive User]

Thanks! This helps me a lot. But do you know how I can change the file name in the Output tool depending on the File?

[binu_acs]

@Inactive User Create full path of your output files in a formula tool then in the output tool configuration tool update like below