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)

chandu

• Apr 28th, 2016

 

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

Sreejan

• May 2nd, 2016

 

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

Mayank

• Jun 23rd, 2016

 

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

Neeru

• 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

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

saigoud

• 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