matching records in 2 different files

[lmit]

Hi all,

I have a input file(First file) with below data

the second fail has only company name like

the output should be he first row from file 1 as its matching abc from 2nd file

Can you please suggest how to achieve this .

really appreciate

Thanks in advance,

lmit

[Anonymous]

Hello lmit,

You can design the job like :

1. use 2 tFileInputDelimited components to read the 2 files
2. use tMap to 'Inner Join' the 2 flows by the column 'company name' as the below

[Anonymous]

attach the test job for your reference. thanks

[lmit]

Hi @Aiming Chen​ thanks for your response

if joins are performed it will be exact match but i want records even if one part of the string matches

like

in the 2nd file

I will have only abc

but in the first file I will have like

abc pvt lim

this record should also be considered

thanks,

lmit

[Anonymous]

Hello lmit,

To archive it, you can design the job like:

1. setup a context variable abc, read the file2 content and setup the context variable 'abc' value by tJavaRow

2 use tMap to filter the condition for the flow of file1 like

attach the modified job matchTest_new.zip for your reference.

[PWunsch_1653032151]

I appreciate the information and advice you have shared. I will try to figure it out for more.

9WSYR Weather

[lmit]

Thanks @Aiming Chen​ for the reply

the position of "abc" is not fixed .

so i tried without using split function by taking the complete column as context but got zero records

Thanks,

lmit

[lmit]

Hi ,

any suggestions please

thanks in advance,

lmit

[lmit]

Hi All,

Any suggestions would really appreciate it

thanks in advance,

lmit