Desinger App - Variable for changing periods

Hello together,

I have a short question, I just looked through this forum and couldn't find a topic that would help me (but I'm sure there is a thread with this topic).

I have a workflow where I import some data, in one column called "Periode" there are numbers for the months , so from 1 to 12.

I could manage that the import data is queried per Designer App, so the User is able to choose the data.

Now I have a filter tool selecting via "[Periode]>=1<=5" which results in a Test.xlsx and I want to add to the import data question a question for changing the periods.

My aim is, that the User doesn't have to open the workflow, so I would like to change it like this:

(Or even nicer with 2 textboxes for the starting and the ending period)

I'm not really an expert in Alteryx, it's more learning by doing, so please consider, that you are talking to an Alteryx beginner. 🙂

Hopefully you can help me.

Greets

Michael

Apps

Accepted answers

RolandSchubert

Hi Michael,

I've added a modified version (2019.1). In general, you can change the version be editing the workflow file. Use a text editor (Notepad, Notepad ++) and replace the version entry with the version you need:

Hope this is helpful.

Best,

Roland

SelectPeriod.yxwz

All comments

RolandSchubert

Hi @treibermichael ,

if I got you right, you have to create a kind of "dynamic filter" to select the periods within the range, the user selected.
I've attached a sample workflow to show, how to hand over selected values (I used a Numeric Up Down tool) to a Filter tool.