Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dynamically Pick current week data from 53 weeks

Hi All,   I have Data for each week starting from Jan to Dec 2019,i want to Pic dynamically the current week data among 53 weeks .   Based on the entries in the excel source file ,every week outp...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous  solution is attached, hope that is what you are looking for.

     

     

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous  solution is attached, hope that is what you are looking for.

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Parry ,

 

Almost achieved desired output ,here my source file is looks as attached & how to create week numbers new column .

 

 

 

Thanks,

Joshi

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous you should put your excel file as source  and  on unpivot step change the column name to "Business  Unit" and rest should work.