Combine Files Based on Column Name

Question

Hello,

I need to combine two files based on column name. I have a template and I need to import the values from another excel value. I need to take each row from the dataset and import those values into the template. I currently have the same naming conventions for the column headers on both files. Thanks in advance!

messi007 · Answer

Dear @Tyler_S1,

Below you can check how to use the union tool:

Regards,

marcusblackhill · Answer

Hey @Tyler_S1 !

Actually, in alteryx you have some ways to do that depending the way you need to do. The classic is the join tool, but you can use find/replace tool in some cases.

The join tool is in the Join tab

In join tool you connect the 2 sources and pick the field to use as key of each one in the configuration.

Hope that help you!

atcodedog05 · Answer

Hi @Tyler_S1

You can use Union tool. Refer this resources and the workflow.

https://community.alteryx.com/t5/Interactive-Lessons/Blending-Data-with-Unions/ta-p/76632

https://help.alteryx.com/current/designer/union-tool

Hope this helps 🙂

Union.yxmd