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

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

Batch Macro

Accepted answers

binu_acs

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

All comments

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/ta-p/20480

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

@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

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703