Joining Non Like Tables in Alteryx

[Mike_at_CG]

Hi All

I am trying to join two tables that are not similar in nature (vertical data vs horizontal data) and also dont share any row or column headers.

Based on the contact sheet and product sheets attached is it possible to arrive at the finished report while maintaining the blank row separating the tables?

Sheet	Product Name
Contact	Phone Number
Contact	Email
Manager	Name
Manager	Email
Contact	Group Distro
Transfer	Type

Price	Quantity	Product	Net	State	City	Time	Location	Distance	Temp
$    6.50	6	Apple	$    39.00	Alabama	Montgomery	1:00pm	Southeast	Far	Hot
$    7.50	7	Orange	$    52.50		Juneau	2:00pm		Far	Cold
$    8.50	8	Pear	$    68.00	Arizona	Phoenix	3:00pm	Southwest	Far	Hot
$    9.00	9	Grape	$    81.00	Arkansas	Little Rock	4:00pm	Southeast	Far	Hot
$  10.50	10	Candy	$  105.00	California	Sacramento	5:00pm	West	Far	Hot
$  11.50	11	Popcorn	$  126.50	Colorado	Denver	6:00pm	West	Far	Warm

Sheet	Product Name
Contact	Phone Number
Contact	Email
Manager	Name
Manager	Email
Contact	Group Distro
Transfer	Type
Price	Quantity	Product	Net	State	City	Time	Location	Distance	Temp
$      6.50	6	Apple	$    39.00	Alabama	Montgomery	1:00pm	Southeast	Far	Hot
$      7.50	7	Orange	$    52.50		Juneau	2:00pm		Far	Cold
$      8.50	8	Pear	$    68.00	Arizona	Phoenix	3:00pm	Southwest	Far	Hot
$      9.00	9	Grape	$    81.00	Arkansas	Little Rock	4:00pm	Southeast	Far	Hot
$   10.50	10	Candy	$  105.00	California	Sacramento	5:00pm	West	Far	Hot
$   11.50	11	Popcorn	$  126.50	Colorado	Denver	6:00pm	West	Far	Warm

Thank you

[alexnajm]

Union by Position then, and make sure to create a blank row with a Text Input to Union in between as well

[DataNath · Accepted solution]

Hey @Mike_at_CG, you can achieve this with a Union tool with a certain configuration, namely Auto Config by Position, Ignore - Continue Processing Records (if you don't want warnings/errors for fields not matching, which they won't) and Set a Specific Output Order. We use a dummy Text Input in between, as well as the First Row Contains Data config of the Input Data tool for those tables that aren't at the top, to retain the field names. Hope this helps!

[Mike_at_CG]

@DataNath - Thank you for the help.  This is working great.