Alteryx Designer Desktop Discussions

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

Filtering Data Query

clarrock
8 - Asteroid

Hi,

 

How do I filter a single column data where Alteryx has to only output values that include +ve values and excludes 0s and -ve values.

 

Also the column header is today's date so it keeps changing and is not a fixed header. This is where I'm stuck

 

Is this possible? 

4 REPLIES 4
Qiu
21 - Polaris
21 - Polaris

@clarrock 
With 2 dynamic Rename tools, it should be possible

Capture2A.PNG

atcodedog05
22 - Nova
22 - Nova

-

shreyanshrathod
11 - Bolide

@clarrock ,

Combined on your previous query, this solution should work.

 

Also, if you feel your query has been resolved, kindly mark that by accepting the solution. This helps other community members while resolving queries.

 

Regards,

Shreyansh Rathod

atcodedog05
22 - Nova
22 - Nova

Hi @clarrock 

 

Adding to my previous solution Click Here you can add this condition in the filter tool to keep only values greater than zero (i,e exclude 0 and -ve)

atcodedog05_0-1620801229629.png

 

Hope this helps ðŸ™‚ Feel free to reach out if you have any questions.

Labels
Top Solution Authors