Not Like Filter

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%")

Developer Tools

Data Investigation

Accepted answers

alexnajm

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

All comments

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

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

binu_acs

@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")

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703