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 does act_1, act_2.....so on, does these are week numbers?

 

If yes, does that mean at end of the year it will be act_53/52 depends on the year, correct?

 

and you want to pick the value from most recent week data is available in the sheet, correct?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for your Time.For all your questions yes is the aswer.

 

 

Those are week numbers and i want to pick most recent week data out of that

 

 

Thanks,

Joshi

  • 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.