topic Re: how to update data based on certain rules in Talend Studio

how to update data based on certain rules

Anonymous — Sat, 16 Nov 2024 06:46:44 GMT

Hi All,

I have a doubt where i have my source file and destination file

source files contains set of details as follow

Source file

now i have one rule in source file Cause is Accident but when i need to write in Destination file it

should write as ACR

Ex:below is set od change i need to do

Finally my destination file should be like this below

Kindly tell me feasible solution. any help is much appreciated

Regards,

Abisha

Re: how to update data based on certain rules

nmodi — Wed, 23 Jan 2019 16:43:33 GMT

this should be very simple, you can use above job logic,

use tFileInputdelimited to read csv file, use tMap with rulefile (tFileInputdelimited) as lookup join & you can generate output (tFileOutputdelimited)based on join logic.

Re: how to update data based on certain rules

akumar2301 — Wed, 23 Jan 2019 19:03:37 GMT

look like simple inner join of two table. you could use tmap as suggested above ot tjoin. both will work.

Re: how to update data based on certain rules

Anonymous — Thu, 24 Jan 2019 09:34:06 GMT

i m unable to get it please find my tMap settings

again i am getting the same Cause in my end file

i need to get ACR instead of Account and RPR instead of repair

can you pleas explain in more detail it will be helpful for me Thanks in advance

Re: how to update data based on certain rules

Anonymous — Thu, 24 Jan 2019 09:47:57 GMT

Hi,

Please try like below.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂