topic check data in file in Talend Studio

check data in file

Ven6 — Wed, 26 Feb 2020 23:01:47 GMT

Hello
My issue is the following. I have 02 databases: db1 and db2
the structures are the following:
db1:

code1	libele1
AAAA	ANTONI
BBBB	BERLINE
CCCC	CARLOS
DDDD	DARLIN
EEEE	ETIENNE
FFFF	FRANCKY
GGGG	GERMAIN

db2:

code2	libele2
AAAA	ANTONI
BBBB	BERLINE
	CARLOS
DDDD	DARLIN
EEEE	ETIENNE
F125	FRANCKY
GGGG	GERMAIN

the job will have to compare each row of the database db1 of the column code1 with that of the column code2

if code1 = code2, send an email: the information is identical.

else

if code1 is different from code2, the job will have to read the column libelle1, take its associated code1 and update it in the column code2

after the job is completed we should have this:

code2	libele2
AAAA	ANTONI
BBBB	BERLINE
CCCC	CARLOS
DDDD	DARLIN
EEEE	ETIENNE
FFFF	FRANCKY
GGGG	GERMAIN

need help please.

Re: check data in file

manodwhb — Thu, 27 Feb 2020 06:28:11 GMT

@ven6 , you can do using tMap.

DB1 is main and DB2 is lookup and join on libele1=libele2 and take two output sections and compare in one code1=code2 and the second one like code1!=code2 and then you populate output 1 to tjavarow and trigger a mail and where not equals of code1,code2 from the second output connect to update flow to update record.

Re: check data in file

Ven6 — Thu, 27 Feb 2020 07:14:10 GMT

Plz can u show me an illustration pleaz !!