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
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
Not Selecting Lookups Record
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
Questions by mittalsalil14
Related Answered Questions
Related Open Questions