Joining Data via Multiple Column Match

[krishnagandhi]

Hi,

So i have a unique field in my data (Service Nu) and i want to match it to another data source where the unique field can match to any one of 3 columns (Concat_Pdt#1,Concat_Pdt#2,Concat_Pdt#3) when it finds a match i need it to return the value in the Days/Weeks/Month column. 

My issue is it is not like a regular join because the joining value could be in any of the 3 columns.

Ideally my output should look like this

Service Nu	PO#	Billed Qty	Billed Rate	Month	Week	Days	DAY	WEEK	MONTH
3001362	4502859958	0.6	53.33000183	0	0	1	140	910	3640
3004329	4502822937	0.5	160	0	0	1	160	1040	4160

I have attached my input data in the workflow

[fmvizcaino · Accepted solution]

Hi @krishnagandhi ,

Since you have 3 possible columns to be used as key, the best solution is to use the transpose tool to put all columns into the same one and do a single join afterwards

Best,

Fernando Vizcaino