Dynamic Values in Script

[thanmaya07]

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.