Hi All,

Requesting to suggest the best approach to validate 15 million string values(employee ids) against given value.
Ex: if employee id of the employee is one of {"a1","a2","a3",................"a150k"}

      then set status of employee to Active.

Note: Given employee ids in excel sheet.

Hi,

This is a complex problem, I would say for sure don't put the values in the rules directly. 

I would think a possible way would be to include the excel spreadsheet in the XOM  and using the POI java library (for example) to search in the excel file directly in java or B2X. 

My 2 cents

------------------------------
Alain Robert

Original Message:
Sent: Fri August 29, 2025 10:45 AM
From: Ali B
Subject: Validation on 15millions string values against given value

Hi All,

Requesting to suggest the best approach to validate 15 million string values(employee ids) against given value.
Ex: if employee id of the employee is one of {"a1","a2","a3",................"a150k"}

      then set status of employee to Active.

Note: Given employee ids in excel sheet.

------------------------------
Ali B
------------------------------