topic Re: Lookup values from file to a db component in Talend Studio

Lookup values from file to a db component

j_ — Fri, 15 Nov 2024 23:28:40 GMT

Hi guys,

I have a file with 10 values..based on the different parameters i filter out the file to one value..now i have to pass the values to a db and create a flag...i dont have common id in file and database..its just based on the values from file i have create a if condition with database rows and create a flag ...

Eg.

My file has values

Row1 A

Row 2 B

row 3 C

Database

row 1 A

Row 2 B

Row 3

Now i have to create a condition

If file.row1 equals to db.row1 or file.row2 equals db.row2 then flag equals Y

How to achieve this..

Re: Lookup values from file to a db component

Anonymous — Mon, 29 Nov 2021 07:33:55 GMT

Add a sequence id for each row after reading data from file and DB, the expression to generate a sequence id is:

Numeric.sequence("file",1,1)

and for DB is:

Numeric.sequence("DB",1,1)

and then do an inner join based on the sequence id on tMap

In the output table, add a new column let's call it flag, set its expression like:

row1.columnName.equals(row2.columnName)?"Y":"N"

Hope it helps!

Regards

Shong

Re: Lookup values from file to a db component

j_ — Fri, 03 Dec 2021 20:48:22 GMT

Thank u..this helps 👍👍