Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

How to select date using Date tool

videet
8 - Asteroid

I have attached workflow below.

I have 2 variable From and To want to update data in from and to variable

I tried below workflow but i was struggling to update data 

Any help please?

12 REPLIES 12
AngelosPachis
16 - Nebula

Hey @videet ,

 

Take a look at the action tools

 

AngelosPachis_0-1622638878713.png

 

If the checkbox is ticked, you want that to display the value you want to replace (so that's your date). You can even leave it unchecked and point it to either value of cell 1 (c(1)) of your text input or c(2).

 

Hope that helps,

 

Angelos

 

atcodedog05
22 - Nova
22 - Nova

Hi @videet 

 

I did few changes. 

 

1st change: your action tool should be set like below to change value of date.

atcodedog05_0-1622638823371.png

2nd change : enable your browse window when successful. To do that go to Menu>View>Interface designer>Properties and set it to show browse tool on success.

atcodedog05_1-1622638886084.png

 

Output :

atcodedog05_2-1622638963891.png

 

Hope this helps 🙂

videet
8 - Asteroid

Hi @atcodedog05 ,

Thank you very much but why browse tool not showing updated value in last,

While running as analytic app its showing updated value but when i run workflow text input and browse tool still have old value.

videet_0-1622639440842.png

videet_1-1622639461449.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @videet 

 

The values changes only when run as an analytic app (asking user for input). When run as workflow it doesnt take values from interface tools it takes values that is already present in the workflow.

 

Hope this helps 🙂

videet
8 - Asteroid

Hi @atcodedog05 ,

 

How do i update already present value (2021-01-01) with what user have selected while run as analytic app.

Thanks.

atcodedog05
22 - Nova
22 - Nova

Hi @videet 

 

You can configure your action tool like below to replace the currently existing value with user input. Here its replacing from 2021-01-01.

atcodedog05_0-1622638823371.png

 

Here is an interactive lesson which might help : https://community.alteryx.com/t5/Interactive-Lessons/Using-Analytic-Applications/ta-p/243106

 

Hope this helps 🙂

videet
8 - Asteroid

@AngelosPachis ,

While i run as analytic app updated value selected by users appears.

when i run the workflow its not appearing in my further tools like in below workflow text input still have old value and not what user has selected as analytic run app.

Can you please help me to get that updated value in my text input and further tools

 

videet_0-1622695100763.png

videet_1-1622695157400.pngvideet_2-1622695173909.png

 

 

videet
8 - Asteroid

@atcodedog05 ,

 

I have checked box as replace specific string but still i am not able to get the updated value selected by user durig analytic run in my text input or further tools

I am attaching my workflow.

It will be very kind of you if you can help.

atcodedog05
22 - Nova
22 - Nova

Hi @videet 

 

The values will be updated only during the run as app. You wont be able to see the flow, you will only be able to see outputs. Hence you can add multiple browse tool and enable them to show as output in interface designer. And the values will remain static in the workflow. It only change during run time and later change back.

atcodedog05_0-1622701086689.png

 

For testing purpose you change the text in text input tool and check. Changing the value in text input tool is similar to values getting changed with user input during runtime. Once you have done testing make sure you set it back to initial default values. So that action tool is able to find and replace.

 

Another way of testing is go to Menu>View>Interface Designer>Test View. Here select the user inputs and click on open debug.

atcodedog05_1-1622701345229.png

This will open a workflow where values are changed as per users input. You can do the testing here too.

 

Hope this helps 🙂

 

Labels
Top Solution Authors