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