Not Selecting Lookups Record

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

Questions by mittalsalil14

Showing Answers 1 - 7 of 7 Answers

And Tut

  • Apr 12th, 2016

You can use the lookup_match function with ! (negation) in an filter by expression component. So the syntax for select in fbe will be
!lookup_match("Lookup File",EmpID)


  • Apr 28th, 2016

use FBE component with following function.......first_defined(lookup(lkp name,in.empid).empid, 123) != empid

  Was this answer useful?  Yes


  • May 2nd, 2016

I think you can use : is_null(lookup("lookup_file_name",EmpID).sal)

  Was this answer useful?  Yes


  • Jun 23rd, 2016

Use Join:
and desired output will be on unused port 0.

  Was this answer useful?  Yes


  • Aug 4th, 2016

Use reformat transformation: out.emp_id :1: lookup("lookup_file",in.EmpId).emp_id;
out.emp_id:2: in.emp_id;

And in reformat select condition: is_null(lookup("lookup_file",in.EmpId).emp_id)
and you will get desired output

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes


  • May 15th, 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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions