Compare data from 2 sources then select the correct one to load into database

[SR2210]

Hi,

I have a requirement that I'm not sure doable in Talend or not. But here's the case;

I have to take the same data which has two sources. Source 1 is from an API (data generated from a system), source 2 is an Excel file (manually input data). I need to take both values and compare them. There's a logic to it. For example, if the difference between the two values is more than 50, then I should take the value from Excel and load to the database. If the difference Is less than 50, I should take the value from API and load to the database.

I know to calculate the difference between the values from both sources is possible, but the next step that is to select data from which source to take and load to the database is my concern.

Is this possible to do in Talend? If yes, may I get some idea how to make Talend "select" the correct source based on the comparison result?

Thank you in advance :')

[gjeremy1617088143]

Hi,

you can do This in a tMap,

you enter your condition in the filter condition of the output.

you can make several output with different filter conditions.

send me love and kudos

[amba1]

Hi could you send a screenshot of your job?