Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I have two tables and need to compare two fields (each one from one table) and based on that I need to get the other field.
Data:
LOAD
"Employee ID",
"Position No",
"Employee Name",
GBGF,
"BF Level4" as "BF Level 4 Name",
"BF Level5",
"Cost Centre",
"Legal Entity",
"Resource Type",
"Employee Class",
"Funding Pool",
"Contract Type",
Region,
"High/Low Cost",
Country,
City,
"Job Title",
"Job Family",
"Job Sub Family",
"FM Name",
"FM ID",
"EM Name",
"EM ID",
"Original Start Date",
"Employee Last Hired Date",
"Vendor Name",
"Vendor End Date",
"Current Week",
Actual,
"Head Count"
FROM [lib://Span/RBWM IT - Discover - GHRS *.xlsx]
(ooxml, embedded labels, table is [All RBWM GHRS - 20 May 2019])
WHERE wildMatch ("BF Level4",'RBWM Sales & Distribution*','RBWM Global Standards*','RBWM SSP*','RBWM Retail Business Banking IT*') and Match("Employee Class",'G','L','S','C');
Detail:
LOAD
// "Employee ID",
// "Position No",
// "Employee Name",
// GBGF,
// "BF Level4" as "BF Level 4 Name",
// "BF Level5",
// "Cost Centre",
// "Legal Entity",
// "Resource Type",
// "Employee Class",
// "Funding Pool",
// "Contract Type",
// Region,
// "High/Low Cost",
// Country,
// City,
// "Job Title",
// "Job Family",
// "Job Sub Family",
"FM Name"as DFNAME,
"FM ID"
// "EM Name",
// "EM ID",
// "Original Start Date",
// "Employee Last Hired Date",
// "Vendor Name",
// "Vendor End Date",
// "Current Week",
// Actual,
// "Head Count"
FROM [lib://Span/RBWM IT - Discover - GHRS *.xlsx]
(ooxml, embedded labels, table is [All RBWM GHRS - 20 May 2019])
WHERE wildMatch ("BF Level4",'RBWM Sales & Distribution*','RBWM Global Standards*','RBWM SSP*','RBWM Retail Business Banking IT*') and Match("Employee Class",'G','L','S','C');
Temp:
LOAD "FM ID",
Country,
"Employee Name"
Resident Data;
Join(Temp)
LOAD "FM ID",
DFNAME
Resident Detail;
Table:
LOAD "FM ID",
if(DFNAME = "Employee Name", Country) as Flag
Resident Temp;
DROP Table Temp;
I have tried this code but it is not giving me any results neither error.
Can some one check I have done any mistakes?
Try this
Rgds,
Shubham Deshmukh