Table transformation

[tww]

Hi all,

I am new to Alteryx. I am trying to combine two tables into one, see below. I am wondering how could I achieve that in Alteryx?

Input 1

COMP	Compliance
Computer_Ops	Computer Operations

Input 2

R01	Existence or Occurrence
R02	Completeness
R03	Valuation or Allocation
R04	Rights or Obligation
R05	Presentation and Disclosure

Output

COMP	Compliance	COMP.R01	Existence or Occurrence
COMP	Compliance	COMP.R02	Completeness
COMP	Compliance	COMP.R03	Valuation or Allocation
COMP	Compliance	COMP.R04	Rights or Obligation
COMP	Compliance	COMP.R05	Presentation and Disclosure
Computer_Ops	Computer Operations	Computer_Ops.R01	Existence or Occurrence
Computer_Ops	Computer Operations	Computer_Ops.R02	Completeness
Computer_Ops	Computer Operations	Computer_Ops.R03	Valuation or Allocation
Computer_Ops	Computer Operations	Computer_Ops.R04	Rights or Obligation
Computer_Ops	Computer Operations	Computer_Ops.R05	Presentation and Disclosure

Thank you in advance for your ideas and suggestions.

[DataNath · Accepted solution]

Hey @tww, if you're wanting a copy of everything in table 2 next to your table 1 values then you can just append 2 to 1 like so:

To create your third field, you'll just need to put fields 1 and 3 together, separated by a full stop like so:

One thing to be careful of is appending - if one or both of your data sets are large then this will lead to a huge dataset and decreased performance as you're blowing up your data to A x B size where A and B are the number of records in your original tables.

If your second table is large you'll also need to change this option to either just warn or ignore and allow all appends:

[tww]

Thank you so much @DataNath