Merging two data sets to create new Columns

[PNW12]

Hi Alteryx Wizards,

Looking for some help to combine two data sets that have some fields that don't map into one data table. I can't figure out how to populate null values for fields that don't map in the output.

Illustrative example tables below: Need to combine #1 and #2 to create the layout of #3.

Table #1

Record	Cost Center	Team	Activity Description	Outcome	Product	Product Spend
1	5110 Category Creation	Corporate Marketing	Brand & Awareness Programs	Brand Awareness	Buying Center - Core	588,000
2	5111 Category Creation	Corporate Marketing	Brand & Awareness Programs	Brand Awareness	Buying Center - Core	5,096,000
3	5112 Category Creation	Corporate Marketing	Assets Acquisition and Creation	Brand Awareness	Buying Center - Core	196,000
4	3111 Analyst Relations	Corporate Marketing	Brand & Awareness Programs	Brand Awareness	Buying Center - Security	700,560
4	3111 Analyst Relations	Corporate Marketing	Brand & Awareness Programs	Brand Awareness	Buying Center - Ops	437,850

Table # 2

Record	Cost Center	Team	Activity Description	Outcome	Region	Region Spend
1	3110 Category Creation	Corporate Marketing	Brand & Awareness Programs	Brand Awareness	Theater - AMER	588000
2	3110 Category Creation	Corporate Marketing	Brand & Awareness Programs	Brand Awareness	Theater - AMER	5096000
3	3110 Category Creation	Corporate Marketing	Assets Acquisition and Creation	Brand Awareness	Theater - AMER	196000
4	3111 Analyst Relations	Corporate Marketing	Brand & Awareness Programs	Brand Awareness	Theater - EMEA	437850
4	3111 Analyst Relations	Corporate Marketing	Brand & Awareness Programs	Brand Awareness	Theater - AMER	788130

output: Table #3

Record	Cost Center	Team	Activity Description	Outcome	Product	Region	Product Spend	Region Spend
1	5110 Category Creation	Corporate Marketing	Brand & Awareness Programs	Brand Awareness	Buying Center - Core	<null>	588,000	0
2	5111 Category Creation	Corporate Marketing	Brand & Awareness Programs	Brand Awareness	Buying Center - Core	<null>	5,096,000	0
3	5112 Category Creation	Corporate Marketing	Assets Acquisition and Creation	Brand Awareness	Buying Center - Core	<null>	196,000	0
4	3111 Analyst Relations	Corporate Marketing	Brand & Awareness Programs	Brand Awareness	Buying Center - Security	<null>	700,560	0
4	3111 Analyst Relations	Corporate Marketing	Brand & Awareness Programs	Brand Awareness	Buying Center - IT Ops	<null>	437,850	0
1	3110 Category Creation	Corporate Marketing	Brand & Awareness Programs	Brand Awareness	<null>	Theater - AMER	0	588000
2	3110 Category Creation	Corporate Marketing	Brand & Awareness Programs	Brand Awareness	<null>	Theater - AMER	0	5096000
3	3110 Category Creation	Corporate Marketing	Assets Acquisition and Creation	Brand Awareness	<null>	Theater - AMER	0	196000
4	3111 Analyst Relations	Corporate Marketing	Brand & Awareness Programs	Brand Awareness	<null>	Theater - EMEA	0	437850
4	3111 Analyst Relations	Corporate Marketing	Brand & Awareness Programs	Brand Awareness	<null>	Theater - AMER	0	788130

Thanks for your help!

[apathetichell · Accepted solution]

I think you can do what you're looking for with a Union tool - make sure you are setting it to Auto Config by Name, Ignore when fields differ, and Output all fields..

[Qiu · Accepted solution]

@PNW12 

Just further developing @apathetichell  idea.