topic Re: Look Up mapping issue in Talend Studio

Look Up mapping issue

mbetbeder1627023970 — Fri, 15 Nov 2024 23:36:51 GMT

Good day,

I’m new with Talend Cloud Studio and I’m getting stuck with the job I’m working on.

Context

My company uses an API directory (Genesys). So far, we use a .csv file to insert / update contacts. This file is generated from a database extract.

We want to automatize this process with a Talend Job.

(A) is my Contacts database extract.

(B) is my API (feeded from A) and used as look up component.

Because there is not always a common field between (A) and (B), we map most of (A) fields to (B)’s so input datas can be « filtered » and redirected to two disctincs output « Inserted » and « Updated ».

Please find my schema attached.

My issue is the following : despite differences between data in (A) and (B), every output are considered as « inserted » (aka new contacts in the directory) and not « updated ».

Please find my result attached.

If anyone as any clue about what’s happening or need more details, feel free to ask me !

Thanks by advance for your help.

Regards

Re: Look Up mapping issue

Anonymous — Wed, 20 Oct 2021 14:08:01 GMT

Things to check:

take care all String typed fields are trimmed in the source component.
your join condition expects in the lookup exact one record matching the join conditions. If there are more than one records the match will not accepted. or you change the join conditions to allow multiple lookup records with the same key.
are you sure the filter for the lookup records are correct? I would use here a context variable to be able to change that without changing the job itself.

Re: Look Up mapping issue

mbetbeder1627023970 — Thu, 21 Oct 2021 15:12:37 GMT

Thank you very much for your answer, I do apologize coming to you so late.

After, checking the type of my fields, I set the join conditions to "All Raw" and run again my job.

I've got the following result : two lines are redirected to the "update" output file and four line are redirected to the "inserted" outputfile.

It's a progress compare to my og post but one issue remains.

Common rows between input and look up files are catched as "updated" and inside the "inserted" output file one row should be considered as updated.

I'm a bit confused about using context variable for this job. Did you mean writing custom java code using conditional clauses like "If" ? Am I suppose to use the "Var" section of the tmap pannel ?

Please find below some screenshots.

Regard