topic Match value to Multiple list in Talend Studio

Match value to Multiple list

RA6 — Sat, 16 Nov 2024 04:56:46 GMT

Hello,

Is it possible to match certain value to some other list?

For example:

For each row of main table, if columnA is found in list_1 AND columnB is found in list_2 AND columnD is found in list_3 OR list_4, it outputs the below result.

Expected Result

Is this one possible?

Can you advice please?

Best regards,

asadasing

Re: Match value to Multiple list

JR1 — Fri, 16 Aug 2019 10:26:07 GMT

Hi,

Try the following:

In a tMap with your main table as input create lookups from all your four lookup tables and join them by the value to check (e.g. DEPARTMENT --> LIST_1). These must all be a Left Outer Joins (standard). In the output create a new column ("Column1" in your post) and put the following in there (replace the lookup table names with the correct "row" identifiers and "COLUMN" with the name of the column in the lookup:

(LIST_1.COLUMN != null && LIST_2.COLUMN != null && LIST_3.COLUMN != null && LIST_4.COLUMN != null) ? "MATCHES FOUND" : null

Hope this helps.

Re: Match value to Multiple list

RA6 — Fri, 16 Aug 2019 14:47:57 GMT

Hello,

Thank you for you response.

Suppose the list1, list2, list3 and list4 is located in only 1 excel file, how can we achieve this?

Thank you.

asadasing

Re: Match value to Multiple list

JR1 — Fri, 16 Aug 2019 15:01:06 GMT

"One Excel file" can mean a lot of things. Do you mean four sheets in the same document, four tables in one sheet or all values in one table in one sheet? One way or the other, you will have to look into the tFileInputExcel component and how it works.