Search results
Job,Id
aaa,1234
ccc,2345
ddd,9879
fff,6743
eee,8754
zzz,4006
Lookup file
Job1, Job2 , Job3
ccc,eee,zzz
ddd,fff,aaa
Output table should look like below:
Job1,...
See more...
Search results
Job,Id
aaa,1234
ccc,2345
ddd,9879
fff,6743
eee,8754
zzz,4006
Lookup file
Job1, Job2 , Job3
ccc,eee,zzz
ddd,fff,aaa
Output table should look like below:
Job1,id1,Job2,id2,Job3,id3
ccc,2345,eee,8754,zzz,4006
ddd,9879,fff,6743,aaa,1234
Tried join, append, appendcols but all are returning incorrect results