Alteryx Designer Desktop Discussions

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

Filtering Data Query

clarrock
Asteroide

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 RESPUESTAS 4
Qiu
21 - Polaris
21 - Polaris

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

Capture2A.PNG

atcodedog05
22 - Nova
22 - Nova

-

shreyanshrathod
Bólido

@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.

Etiquetas
Autores con mayor cantidad de soluciones