Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Automatically create new columns based on a condition

bala_psu
5 - Atom

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.

1 REPLY 1
DavidSkaife
13 - Pulsar

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:

 

DavidSkaife_0-1658482584914.png

 

 

Labels