Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@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.
Plz can u show me an illustration pleaz !!