how to compare previous month with current month using apply map
Hi,
we are having two tables .both the tables have ID in common we are linking through it.if particular ID is not found we are displaying it as "Not Available".if ID is not available it should display the previous Month department only for those which is "Not Available".
using applymap we got Not Available .
and the below code is for those who are not available for them we are trying to get the department from previous month table.
Map_Emp:
Mapping Load
" ID" ,
"Department"
Resident table1;
Missing_ID:
load
"user id" as Missing_ID,
Month_Year as [Month-Year],
Dept,
ApplyMap('Map_Emp',"user id") as Missing_Department