In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

how to identify

hi2019
8 - Asteroid

I want to identify any , inside the Payee name column - would that be a fomula? or filter?

 

I would like to create a column with these so I can then create another formula that has comma, plus other things to have them filter out to another MAnual tab.

 

Example : 

 

If [Payee Name Count] = '1'
AND [ID Codes] != 'ENT'

AND ------------if payee name has commas

THEN 'Manual Review'
else [Sheet Name] ENDif

1 REPLY 1
BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

@hi2019  If you're checking if cells within a column contain a comma "," then you could use the contains formula: Contains([field here], ",")

 

All the best,

BS

All the best,
BS

LinkedIN

Bulien
Labels
Top Solution Authors