Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two table where month and year is used. I have attached the sample coding of that below :
Map_load:
Mapping load
"ID" ,
'Assigned' as PrjAssignment
Resident Assign
where Month_Year='Jun-2016';
//Assignment_Status:
join (Employees)
Load
"ID",
ApplyMap('Map_load',"ID",'Not Assigned') as Status
Resident Employees
where Month_Year='Jun-2016';
Here the month and year should be dynamic for example if I have march,april,may it should take it dynamically without specifying in where clause like how it is done above. Any possible solutions for this ?
where Month_year=date(today(),'MMM-YYYY')
TODAY will consider only today's month year for examply only july.But i have march and april also in the data how to fetch that
where Month_Year >= date(addmonths(today(),-4),'MMM-YYYY')
Use as follows
Map_load:
Mapping load
Month_Year&'|'&ID ,
'Assigned' as PrjAssignment
Resident Assign;
//Assignment_Status:
join (Employees)
Load
ID,
ApplyMap('Map_load',Month_Year&'|'&ID,'Not Assigned') as Status
Resident Employees;
Can you pls explain the logic for this ?