how to update data based on certain rules

Highlighted
Six Stars

how to update data based on certain rules

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

Capture2.PNG

 

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

 

Capture4.PNG

 

 

Finally my destination file should be like this below

 

Capture3.PNG

 

 

Kindly tell me feasible solution. any help is much appreciated

 

Regards,

Abisha


Accepted Solutions
Employee

Re: how to update data based on certain rules

Hi,

 

    Please try like below.

image.png

 

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 :-)


All Replies
Seven Stars

Re: how to update data based on certain rules

joblogic.PNG

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.

Eleven Stars

Re: how to update data based on certain rules

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

Re: how to update data based on certain rules

Hi 

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

 

 

 

tmap.PNG

 

 

 

destfile.PNG

Employee

Re: how to update data based on certain rules

Hi,

 

    Please try like below.

image.png

 

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 :-)

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

An API-First Approach to Modernizing Applications

Learn how to use an API-First Approach to Modernize your Applications

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now