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!
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 🙂
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!