Merging 3 or more Outputs into 1

[k3pineapple]

Hi Expects

Seeking your help to merge the outputs. Trying to use transpose + crosstap, seems not went well

Unique Identified: UID

Rule: if UID the same between/among outputs, amend extra field.

Thank you very much

Sample:

1.

UID	CID	Client	Enabled Date	Activity Date	Sales
123456	111	ABC Inc	10/3/2022	1/3/2023	Amy
233333	213	233 Ltd	11/2/2023	2/6/2023	Bob

2.

UID	CID	Client	City	Region
123456	111	ABC Inc	NYK	America
123457	111	ABC Inc	LDN	Europe
222222	222	Super ltd	LDN	Europe
233333	213	233 Ltd	SHH	ASIA

3.

UID	CID	Client	Status	Channel	Requested Date
123456	111	ABC Inc	Enabled	Email	9/30/2022
333333	333	TTT Ltd	Pending	Main	5/1/2023

sample output (no matter about order)

UID	CID	Client	Enabled Date	Activity Date	Sales	City	Region	Status	Channel	Requested Date
123456	111	ABC Inc	10/3/2022	1/3/2023	Amy	NYK	America	Enabled	Email	9/30/2022
123457	111	ABC Inc				LDN	Europe
233333	213	233 Ltd	11/2/2023	2/6/2023	Bob	SHH	ASIA
222222	222	Super ltd				LDN	Europe
333333	333	TTT Ltd						Pending	Main	5/1/2023

[dbmurray]

I'm a bit confused - did you mean amend or append?

The main issue from what I can see is in your data - different tables have different combinations of UIDs. Eg. Table 2 has 222222 which doesn't exist in Table 1.

Can you provide us with the expected output?

[Felipe_Ribeir0 · Accepted solution]

Hi @k3pineapple 

One way of doing this: