topic Re: matching records in 2 different files in Talend Studio

matching records in 2 different files

lmit — Tue, 30 Aug 2022 15:14:55 GMT

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

Re: matching records in 2 different files

Anonymous — Wed, 31 Aug 2022 02:24:42 GMT

Hello lmit,

You can design the job like :

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

Re: matching records in 2 different files

Anonymous — Wed, 31 Aug 2022 02:25:32 GMT

attach the test job for your reference. thanks

Re: matching records in 2 different files

lmit — Wed, 31 Aug 2022 02:38:35 GMT

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

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

Re: matching records in 2 different files

Anonymous — Wed, 31 Aug 2022 03:18:21 GMT

Hello lmit,

To archive it, you can design the job like:

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.

Re: matching records in 2 different files

PWunsch_1653032151 — Wed, 31 Aug 2022 10:06:45 GMT

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

9WSYR Weather

Re: matching records in 2 different files

lmit — Wed, 31 Aug 2022 13:31:33 GMT

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

Re: matching records in 2 different files

lmit — Thu, 01 Sep 2022 12:13:53 GMT

Hi ,

any suggestions please

thanks in advance,

lmit

Re: matching records in 2 different files

lmit — Thu, 08 Sep 2022 17:07:17 GMT

Hi All,

Any suggestions would really appreciate it

thanks in advance,

lmit