JOINING MULTIPLE RECORDS WITH DIFFERENT SPECIFIC FIELDS

[dunkindonut7777]

Hi I have 3 files here that I want to combine together in one tool. 

Data 1

ID	Store	Customer	Source
111	California	J.Ana	SA
123	Texas	Dave.L	DA
124	Florida	H.Carl	GA

Data 2

ID	Category
111	N
124	L
123	G

Data 3

Source	Source Category
SA	System
DA	Spreasheet
GA	Cost Sheet

Expected output:

ID	Store	Customer	Source	Category	Source Category
111	California	J.Ana	SA	N	System
123	Texas	Dave.L	DA	G	Spreasheet
124	Florida	H.Carl	GA	L	Cost Sheet

Is there any other way to combine it easily in just one tool? even though they have different common fields per file? Could you help me with this one pls? 

[afv2688]

Hello @dunkindonut7777 ,

There is no way to join two or more files based on different common fields on a same tool. There is on the other way a way to create a system that automatically detects the common fields and uses them to join the files togheter. This system depends on both files having the same name for the common fields. It is something I created a while ago.

Hope that helps.

Regards