remove rows with a specific character

[adamvallelunga]

Hi,

New to Alteryx...was wondering if there is a way to remove rows, that their 2nd to last character is zero(0)?

Would it be within the regular filter query. Thanks, Adam

[Thableaus · Accepted solution]

Hi @adamvallelunga 

You could use a Filter tool with something like this:

Left(Right(ToString([ACCOUNTID]), 2), 1) != "0"

Cheers,

[JosephSerpis]

Hi @adamvallelunga if you use this syntax should work IF Substring([AccountID],7,1) ="0" THEN "Remove" ELSE "Keep" ENDIF

[adamvallelunga]

Thanks Thableaus, it works; much appreciated!

Adam