topic Re: tMAP Join in Installing and Upgrading

tMAP Join

Anonymous — Wed, 04 Jan 2017 11:40:27 GMT

Hi Team
I have a requirment, I want to join to files based on column which has some discrepency like
Source File:
ColA
xyz
abc
lkj
LookUp File:
ColA
post,xyz
abc,deu
so I want to join xyz with post,xyz & abc with abc,deu
I cannot use split function because separator is not constant it is changing across the file.

Re: tMAP Join

Anonymous — Thu, 05 Jan 2017 03:48:27 GMT

Hi,
What does your expected result look like? Could you please also post your expected result on forum?
Best regards
Sabrina

Re: tMAP Join

Anonymous — Mon, 09 Jan 2017 12:13:13 GMT

Hi

Thank for your reply

Output
Col A Col B
xyz post,xyz -- as xyz matching
abc abc,deu -- as abc matching
lkj --