Filtering Data Query

[clarrock]

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? 

[Qiu]

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

[atcodedog05]

-

[shreyanshrathod]

@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 · Accepted solution]

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)

Hope this helps 🙂 Feel free to reach out if you have any questions.