How to join two tables and dynamically organize headers?

Joker_Hazard

Hi

I currently have two tables

COLUMN F	COLUMN G	COLUMN H	COLUMN I	COLUMN J	COLUMN K	COLUMN l	COLUMN M
Dummy data	Dummy data	Dummy data	Dummy data	Dummy data	Dummy data	Dummy data	Dummy data
Dummy data	Dummy data	Dummy data	Dummy data	Dummy data	Dummy data	Dummy data	Dummy data
Dummy data	Dummy data	Dummy data	Dummy data	Dummy data	Dummy data	Dummy data	Dummy data
Dummy data	Dummy data	Dummy data	Dummy data	Dummy data	Dummy data	Dummy data	Dummy data
Dummy data	Dummy data	Dummy data	Dummy data	Dummy data	Dummy data	Dummy data	Dummy data

COLUMN A	COLUMN B	COLUMN C	COLUMN D
Dummy data	Dummy data	Dummy data	Dummy data
Dummy data	Dummy data	Dummy data	Dummy data

When I join them with manually editing the fields in join tool it unfortunately stays as "HOW IT IS" instead of "NEED TO BE"

I really need help with this, i could not find any workarounds for it.

thanks

Dhrish

Hi @Joker_Hazard

If you have the tables as input files then you can do something like this

1st screenshot if of the workflow and the union tool config

2nd for input tool

3rd for output tool

If the tables are inside Alteryx then you can add the column names as a row into the data. Refer the workflow attached.

Hope this helps

How to join two tables and dynamically organize headers.yxzp