Exclude specific item(s) from existing column into a new column

Hello,

I have a simple query but cannot do successfully after trying a few methods.

I have an existing column of data which is all good, however, I now need to create a new column with a couple of the existing items removed from it.

For example:

My ExistingColumn has all these items but now need a NewColumn to exclude eg the work Mango from it.

Hope its an easy

Many thanks in advance.

Regards

Workflow

Tableau

Expression

Accepted answers

RobertOdera

Hi @PamG

try the below in a formula tool for NewColumn, where

IF !CONTAINS([ExistingColumn],"Mango")
THEN [ExistingColumn]
ELSE Null()
ENDIF.

Cheers!

For_PamG.yxmd

All comments

FrederikE

Hey @PamG,

You can just duplicate the column via a formula and then use Find&Replace with an Input/Text Input of a list of items that should be removed.

Make sure all fields are string for F&R.

RobertOdera

Hi @PamG

try the below in a formula tool for NewColumn, where

IF !CONTAINS([ExistingColumn],"Mango")
THEN [ExistingColumn]
ELSE Null()
ENDIF.

Cheers!

For_PamG.yxmd

PamG

Hiya @RobertOdera

This is brilliant. Thanks so much for this, it worked brilliantly and a tad simpler too!

Thanks also @FrederikE

RobertOdera

You're most welcome @PamG!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703