Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Automatically Update a Range when a Parameter Changes

YLYONG
9 - Comet
‎09-25-2021 03:13 AM

Hi Alteryx Community,

Wanting to get your help on below:

Is there a more elegant way to automatically update the range (in yellow) when the parameter (the first two formulas) is changes.

 

I' be happy to upload the workflow however, as you can see below, it is quite extensive...

thank you 

 

 

YLYONG_1-1632564169527.png

 

YLYONG_2-1632564200515.png

 

YLYONG_3-1632564231578.png

YLYONG_4-1632564304950.png

 

Labels:
Reply
0 Likes
2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris
‎09-25-2021 03:43 AM

@YLYONG 
I prefer a matching table, which will much flexible.

Capture3B.PNG

Capture3V.PNG

New Workflow3.yxmd
Reply
YLYONG
9 - Comet
‎09-25-2021 05:02 AM

@Qiu Thank you for your input. This means duplicate this workflow, change the fields to populate the other range:

 

YLYONG_0-1632571108431.png

 

YLYONG_1-1632571139605.png

 

Reply
GenAI Contest Form
Data Connection Manager
Labels
Top Solution Authors
View All