Thanks for your immediate reply and it is helpful.
But what If I try to apply some conditions on the Level Field of Emp_SKill and Required SKill of Project together.
For that case, i should join the Required SKill to the Emp_SKill table and then only will I be able to make some conditions?
Or is there any alternative??
Actually, I have four value fields in Project sheet and one value field in Emp Sheet, and the cases are different with each other, so what could be best practice to achieve the cases
The output I want to see is a pivot table and the desired output is:
Project Skill ID Name RequiredMinLevel RequiredIdeal Level Level Gap(Expression) Sales C 1 Ravi 3 4 2 Red C++ 1 Ravi 2 3 4 Green Java 1 Ravi 2 4 3 Amber HTML 1 Ravi 1 3 1 Amber Finance Java 2 Raj 3 4 0 Red C++ 2 Raj 2 3 2 Amber HR Java 3 Ashok 0 0 3 Blue People Management 3 Ashok 3 4 4 Green
The RequiredMinLevel and RequiredIdealLeval are fetching from the Project Sheet.
Name is fetching from the Employee sheet.
Gap is the Condtion like
IF Level is Between Min And Ideal------- Amber
and if ReuiredMinLevel and RequiredIdealLevel =0 and Level>0--- Blue
Thanks in advance.
Hi Sindhu, Try like below:
LOAD EmpID, Skill, Level From EmpoyeeTable;
Left Join (TempEmpSkils)
LOAD EmpID, Project From EmPProjectTable:
LOAD EmpID, Skill & '-' & Project AS ProjectSkillKey , Level Resident TempEmpSkils ;
DROP Table TempEmpSkils ;
LOAD Skill & '-' & Project AS ProjectSkillKey , Skill, Project , RequiredMinLevel, RequiredDealLevel From ProjectDetails;
These 2 tables are linked on ProjectSkillKey and we will get the desired Pivot table output.
If not, Please provide the all the fields data.