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

Alteryx Designer Desktop Discussions

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

Filtering through Analytical App not working

Paridhi_Agrawal
8 - Asteroid

Hi,

 

I have this attached workflow, When I run it as an app and select any value for filter tool, The result is not coming as expected.

 

Can anyone help me in this.

 

Thanks

Paridhi

6 REPLIES 6
Felipe_Ribeir0
16 - Nebula

Hi @Paridhi_Agrawal 

 

Your workflow is not working properly because when you use the list box, the data that comes out of the update value tool looks like this:

 

consumer.png

 

So, you need to deal with this data before filtering the main dataset. Check the attached workflow, i basically turned the above dataset in one can be joined against the main dataset.

deal.png

Paridhi_Agrawal
8 - Asteroid

hi, 

How did you see the values coming from update value tool (Action tool)?

Felipe_Ribeir0
16 - Nebula

@Paridhi_Agrawal one trick to do this is by updating a text input file, writting the result of it to an output, make this output open after running the app and finally run the app:

 

output1.png

output2.png

Paridhi_Agrawal
8 - Asteroid

thanks so much!

PhilipMannering
16 - Nebula
16 - Nebula

Here's another, more concise way to do it,

 

image.png

Felipe_Ribeir0
16 - Nebula

@PhilipMannering i didnt know this way of doing, thanks for sharing.

Labels