In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Filtering out values more than certain value

InfoManager
7 - Meteor

I'm trying to filter out all records with a value over 12 Billion. In the input file, I've converted all of the values to make sure they're numeric. Then, I even added a select tool into the workflow right before the filter to remove all values over 12 billion to ensure that the field I'm trying to filter is still numeric. I changed it from v_string to fixed decimal. Now I want to filter out any value over 12 billion. I tried the filter function and constructed a function that reads [CompanyMarketCap] < "12,000,000,000". I'm now getting a message that "<" is an invalid operator. I'm wondering if I need to try something totally different. 

 

Any help is most appreciated!

1 REPLY 1
InfoManager
7 - Meteor

Looks like I posted too soon. I think I got it. I removed commas from my original data, changed the field from v-string to fixed decimal and input the filter again without the commas, and it now seems to work. :)

Labels
Top Solution Authors