Copy Paste or Append as per column name

[salmansadatkarim]

Hi, I am new in Alteryx and just wanted to know if the following is doable in Alteryx.

I have an Excel sheet with the following columns and values 

Table-1

Srl No	Customer Name	Customer No	Business Segment	Activity
1	ABC Company	001-123456	Multi National	Active
2	DEF Company	001-789123	SME	Inactive
3	GHI Company	001-456789	Corporate	Active

I want to add the following in the first table

Table-2

Srl No	Customer Name	Customer No	RM Name	Business Segment	Activity
1	JKL Company	002-123456	Ruby	International	Active
2	MNO Company	002-789123	John	Large Business	Active
3	PQR Company	003-456789	Amy	Sole Prop	Active

So the output becomes like the following. Please note, I need to be able to pick only the relevant columns from Table-2.

Table-3

Srl No	Customer Name	Customer No	Business Segment	Activity
1	ABC Company	001-123456	Multi National	Active
2	DEF Company	001-789123	SME	Inactive
3	GHI Company	001-456789	Corporate	Active
4	JKL Company	002-123456	International	Active
5	MNO Company	002-789123	Large Business	Active
6	PQR Company	003-456789	Sole Prop	Active

Thanks in advance.

-Salman

[MelGibson · Accepted solution]

I hope this is what you are looking for. 

[salmansadatkarim]

Thank You so much for taking time and providing this solution! This worked perfectly. Thank You!