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.
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.
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.
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.
