We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Dynamically Fill a column with values from another column

apatel1501
8 - Asteroid

I have the attached dataset with 3 years of sales and margin data.  However, my dataset will sometimes have 4 or 5 years or more. I'm able to dynamically calculate the Min_Period and the Max_Period from an earlier portion of the workflow. I want to fill the Min_Period with P01_Sales and Max_Period with P03_Sales. The problem is, the Max_Period may sometimes be P04_Sales or P05_Sales so a regular formula won't work.

 

Any ideas on how i can get Max_Period value to recognize the latest sales year and fill the cell with those values? For instance - Max_Period Row 1 should = P03_Sales Row 1.

 

Thanks!

 

 

3 REPLIES 3
apatel1501
8 - Asteroid

Attaching the data in excel in case its helpful

binuacs
21 - Polaris

@apatel1501 created a workflow based on my understanding

image.png

apatel1501
8 - Asteroid

Thanks! That worked - appreciate it!

Labels
Top Solution Authors