Match value to Multiple list

[RA6]

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

[JR1]

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.

[RA6]

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

[JR1]

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