I have data like below. source file: EmpID sal A 1000 B 2000 C 3000 D 4000 Lookup File EmpID A B Output File EMPID Sal C 3000 D 4000 I want empId, sal of employees those not present in lookup file

saigoud

• May 16th, 2017

Use the components lookup and Filter_by_expression and write the code
lookup_count("Lookup File",empid)==0 in FBE you will get this output

Garima Takur

• Nov 27th, 2016

Use FBE component and give he select condition as !(lookup_match("lookup_file",in.emp_id) the output in select port will be the required result

Answer Question  Select Best Answer