Table transformation

Question

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

COMPComplianceComputer_OpsComputer Operations

Input 2

R01Existence or OccurrenceR02CompletenessR03Valuation or AllocationR04Rights or ObligationR05Presentation and Disclosure

Output

COMPComplianceCOMP.R01Existence or OccurrenceCOMPComplianceCOMP.R02CompletenessCOMPComplianceCOMP.R03Valuation or AllocationCOMPComplianceCOMP.R04Rights or ObligationCOMPComplianceCOMP.R05Presentation and DisclosureComputer_OpsComputer OperationsComputer_Ops.R01Existence or OccurrenceComputer_OpsComputer OperationsComputer_Ops.R02CompletenessComputer_OpsComputer OperationsComputer_Ops.R03Valuation or AllocationComputer_OpsComputer OperationsComputer_Ops.R04Rights or ObligationComputer_OpsComputer OperationsComputer_Ops.R05Presentation and Disclosure

Thank you in advance for your ideas and suggestions.

DataNath · Accepted Answer

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: