Join in multiple columns

[maxiemens]

Hi guys I have the following Problem: 

 

I want to join the data in multiple columns, not only in one. With the join tool you only can join in one column, but in my data i have three columns to join.

Do you know how can I do it. I hope the example helps what i want to do.

Thanks for your help.

[sonaliyadav]

I havent done it myself ever, but from the top of my head, why dont you try

1. splitting the columns into 3 parts each containing Order ID, batch, date and amount. Split using 3 select tools.

2. then join these with the other file separately and

3. then union

Let us know if this helped

[LordNeilLord · Accepted solution]

Hey @maxiemens 

That was much more complicated than I thought it was going to be!

But this should get you close to what you need

[grazitti_sapna · Accepted solution]

Hi @maxiemens , this is the easiest way to solve this problem, I hope this helps.

Thanks.