Want to join multiple dataset

[Sshasnk]

I have multiple data sets which I want to join based on a parameter horizontally, For now, I will take 3 datasets but for me, I have 8 datasets

Dataset 1:

Fund	amount	code	name
ABC	123	4895	Alex
LMN	456	789	Luke
NJP	4789	456	Kim

Dataset 2:

Fund	Purchase	last name
ABC	123	Sky
LMN	145	MN
NJP	789	Jr

Dataset 3:

Fund	Sell
ABC	456
LMN	12
NJP	13

Output:

Fund	amount	code	name	Purchase	last name	Sell
ABC	123	4895	Alex	123	Sky	456
LMN	456	789	Luke	145	MN	12
NJP	4789	456	Kim	789	Jr	13

I am actually trying to optimize the solution because I don't want to use 8 joins all over the place (as I have 8 datasets) 

[DenisZ · Accepted solution]

Please see attached workflow

You can leverage the Join Multiple tool for this. 

Please mark it as solved if it solves the issue

[KrishnaChithrathil]

@Sshasnk 

you can use either 2 Join Tool or Join Multiple Tool. Either way it'll work. But I'd recommend to use join multiple.

the workflow I've shared contains both the tools. you can pick either.

OR