Join without repeating every field

[zkreflex]

Hi all,

So I want to join data source 1 and 2 on the first column, but I don't want the 2nd field in data source 1 to repeat (see Output grid).  Is there any easy way to accomplish this?

Data Source 1
W	5
X	3
Y	10
Z	7

Data Source 2
W	A	5
X	B	5
X	C	5
X	D	5

Output
W	5	A	5
X	3	B	5
X		C	5
X		D	5
Y	10
Z	7

Thanks!

[Mikepr · Accepted solution]

Hope this helps you. 

[marapatricia]

Hello @zkeller,

You may also check the attached solution. Hope it helps.

[zkreflex]

Thanks! Worked perfect.