Filtering Data Query
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@clarrock
With 2 dynamic Rename tools, it should be possible
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
-
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.