Not Like Filter

[nicktekippe]

This formula does not work in Alteryx. I need the formula to filter out any rows where the QNOTE_DESCRIPTON Contains any of the strings in the formula below.

[QNOTE_DESCRIPTION] not like ("%RETEST PASS%", "%NO CHANGE%", "%NO R%", "%CHRISTMAS TREES%", "%NO REPAIR%") 

[rfoster7]

[QNOTE_DESCRIPTION] like '%RETEST PASS%'
or [QNOTE_DESCRIPTION] like '%NO CHANGE%'
or [QNOTE_DESCRIPTION] like '%NO R%'
or [QNOTE_DESCRIPTION] like '%CHRISTMAS TREES%'
or [QNOTE_DESCRIPTION] like '%NO REPAIR%'

put that in your filter formula, then use the F output instead of the T output. 

[alexnajm · Accepted solution]

I don't think there is a LIKE function in Alteryx - I would look at the CONTAINS function:

Contains([QNOTE_DESCRIPTION],"RETEST PASS")

or Contains([QNOTE_DESCRIPTION],"NO CHANGE")

or Contains([QNOTE_DESCRIPTION],"NO R")

or Contains([QNOTE_DESCRIPTION],"CHRISTMAS TREES")

or Contains([QNOTE_DESCRIPTION],"NO REPAIR")

then as @rfoster7 mentioned, use the F output instead of the T output for your Filter tool

[binuacs]

@nicktekippe using not operator

!Contains([QNOTE_DESCRIPTION],"RETEST PASS")
AND
!Contains([QNOTE_DESCRIPTION],"NO CHANGE")
AND
!Contains([QNOTE_DESCRIPTION],"NO R")
AND
!Contains([QNOTE_DESCRIPTION],"CHRISTMAS TREES")
AND
!Contains([QNOTE_DESCRIPTION],"NO REPAIR")