Free Trial

Alteryx Designer Desktop Discussions

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

Automatic change input parameters

ChrisVK
6 - Meteoroid

Hello,

 

We've got a workflow with input parameters which is working fine.

The input parameters (Begin week and End week) can be entered manually in textboxes. These entered values are used in a query on a database.

 

We want to extend the flexibility of this flow. The workflow should run automatically every week on a monday and take the last week before that monday as input parameter.

 

Attached you will find an image of the beginning of the flow.

 

I hope I've explained our issue clear enough.

2 REPLIES 2
PhilippK
Alteryx Alumni (Retired)

Hi @ChrisVK ,

 

please find the solution attached:

screenshot.png

 

For the scheduling part, you need the Alteryx Server or the Desktop Automation license for your Alteryx Designer.

 

Have a great day

Phil

ChrisVK
6 - Meteoroid

Hello Philipp,

 

Thank you for your reply and solution. It wasn't quite the solution yet, but it put me on the right track. I added another step to get the previous week based on the previous weekday.

 

Kind regards,

Chris

Labels
Top Solution Authors