Quickly joining multiple collumns

Luqman

Hi, I need to validate one file against another file, 

Sample

File 1				File 2
Set A	Set B	Set C				Set A	Set B	Set C
John	Pikachu	Erine				Elisa	Luqman	Joshua
Bob	Farah	Squirtle				Charmander	Daniel	Elina
Elisa	Luqman	Joshua				John	Pikachu	Erine
Charmander	Daniel	Elina				Bob	Farah	Butterfree

Currently im using three join tools(for each Set A/B/C). I wish to only use one(as actual files has 54 collumns)


I believe it might be with Transpose/Tile tool, but not sure how to set it

Qiu

@Luqman 
Maybe we can use a transpose Tool, then Join the Name and Value fields, which will be dynamic.

0904-Luqman.yxmd