Dynamic input/Union/Batch macro for csv files in different schema

[askoczylas007]

Hi Alteryx Masters!

I have a problem with combine a few csv files in different schema. I want to receive results like with using the Union Tool. 

I tried to use the batch macro and dynamic input but all values from second and third file goes to the columns from the first file.

I would like to avoid using the Union Tool because in workflow it is supposed to be used for a large number of files and I want it to reads all files from a given folder.

Please help :)

[binu_acs]

@askoczylas007 The below post might helpful for your use case 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

[askoczylas007]

Unfortunately not :( I've tried to use all of the solutions from this post before and I am not receiving excepted output. 

[binu_acs]

@askoczylas007All your files are having different column names ? In the batch macro can you check the option selected ‘ Auto configure by name’ in the interface designer 

[askoczylas007]

Let's say that only one column is the same in each file. You can see it on the screen below - this is the result after using Union tool.

This is what I am receiving using dynamic input

When I am using batch macro which is configured by Name.

[binu_acs · Accepted solution]

@askoczylas007 Can you connect the batch macro to a browse tool and run again and check the result from the browse tool ?

[askoczylas007]

OMG! I was so simple! Thanks a lot. 

[askoczylas007]