Dynamic Column Names

[balaji_m]

Hi Team,

I have a requirement like this.

Below are the field Names

[2016 Actual]

[Q3 Target Letter Plan YTD Aug]

My Requirement is the Hardcoded Values like Year, Month has to changed dynamically in the script level.

The data will be loaded on 15th of every month.

So it should be Current Month - 1 and the Year should be calculated as Current Year

Need your inputs on this.

Regards,

Senthil

[petter]

It could be done like this: