Automatically create new columns based on a condition

[bala_psu]

Context: Need to build forecast for the future weeks.

How to automatically create new columns 28 to 52 based on a condition (52 - Max (past weeks)) assuming I have data for the past 27 weeks.

[davidskaife]

Hi @bala_psu 

Here is one way of doing it. Find the max week number, use the generate rows tool to generate rows between the max and 52, use the dynamic rename tool to take the data and make them headers, then union back to your existing data: