Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Replace word in column by Null()

Highlighted
5 - Atom

Hi 

 

I would like to know, how I can set up a formula that replaces the content of a column with Null() if the cell contains a certain word: 

 

Word * -> Null()

 

I alredy tried this: 

 

If REGEX_Match([COLUMN],"Word[") then Null()

 

Thanks a lot for your support! 

 

 

 

Highlighted
12 - Quasar
12 - Quasar

you can use the contains([column], 'word') instead of the regex_match since you aren't finding a pattern. 

Highlighted
15 - Aurora

Can you not just use:

 

if Contains([Column],"TheWord") then Null() else [Column] endif

Highlighted
5 - Atom

Thank you, it worked! 

 

Maybe an additional question: What if I wanted to include different words? 

Highlighted
12 - Quasar
12 - Quasar

different words, like a list of words you want to identify? Then you can pass them through the find/replace and append some value so you can write the formula that if that value exists, make that field null().

 

jarrod_0-1593176849751.png

jarrod_1-1593176932793.pngjarrod_2-1593176958305.png

jarrod_3-1593176969237.png

 

 

Labels