topic Re: Traduction table for IDs in Talend Studio

Traduction table for IDs

VerdaderoKiwi — Sat, 16 Nov 2024 02:56:45 GMT

Hello all! I am using Talend Open Studio and i wan to know i there is a component that allow me to change in execution time the field value in a flow for another one preconfigured value.

This is because i am copying data between two company databases and the compay code in each database can be different. I want to use a componente like this:

Original value Destination value

3 7

5 10

So, if the process finds a company code 3, it changes it to 7 and if it finds 5, to 10, and if any code is found, the it would put a default value or a value from another field.

The objetive is that a simple user can use the translation table codes to say to the process the pair codes of both databases so the data from original company is passed to the destination company.

Thanks,

Marcos.

Re: Traduction table for IDs

TRF — Wed, 18 Mar 2020 20:37:08 GMT

The simplest is to have an Excel or csv file with these values, then use or as a lookup for a tMap component. In tMap, define a left outer join between the main and lookup flows. In tMap output flow you may have an expression to use a default if the value is not found in the lookup flow.
This a very common situation.

Re: Traduction table for IDs

VerdaderoKiwi — Thu, 19 Mar 2020 10:47:08 GMT

Thank you so much for your answer.

I was trying to use a component for this, like a manual excel sheet component, traduction table, or something like that inside the job, and thinking better, an external excel file may be a better solution.

Thanks, i'll do that.