Hi all,
Need help for one of my requirement.
Lets say I have an excel which has values,
Product, KPI Name, Target days
P1,K1,15
P1,K2,15
P2,K1,25
P2,K2,25.
These are the values in excel. I have loaded these values.
In the existing tables, I have dateassigned column.
Logic required:
All these days For Target date used the below logic
LastWorkDate(DATEASSIGNED,15) AS Target_date.
But now I need to get this 15 value dynamically. i.e.,Target days column from loaded excel Based on Product and KPI name.
Help me in implementing this.