Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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