Alteryx designer Discussions

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

remove rows with a specific character

Highlighted

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

 

clipboard_image_0.png

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @adamvallelunga 

 

You could use a Filter tool with something like this:

 

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

 

 

 

Cheers,

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

 

Remove_Row_270819.PNG

Highlighted

Thanks

 

Labels