Is there a way to filter out integers that are longer than 7 digits?

damen · 2022-11-15T15:49:03+00:00

There was an error rendering this rich post.

Hi all,

So I am working through an ETL and the logic needs to be able to include the bottom two values into a bucket but take the top two out.

I am using a formula that looks something like this:

what it really need to be is:

when `loan number` like '5%' and less than 7 digits then ''

is there a way to program that into the logic? I am unfamiliar with how the syntax would look on that.

TIA

Find more posts tagged with

Beast Mode

Accepted answers

MichelleH

@damen If an integer has less than 7 digits, then you could filter to numbers less than 1,000,000 rather than by length (assuming the data type is numerical). So for example:

when `loan number` like '5%' and `loan number` < 1000000

All comments

Jones01

@damen can you just include AND LENGTH(CONCAT(`LOAN NUMBER`, '')) < 7

MichelleH

@damen If an integer has less than 7 digits, then you could filter to numbers less than 1,000,000 rather than by length (assuming the data type is numerical). So for example:

when `loan number` like '5%' and `loan number` < 1000000