Removing things

Hi all,

I have things that start with the word "Total" for example "Total for 4900 Other Miscellaneous Income" or "Total for 8330 Gas & Electric". There are a lot of these that are different but all start with "Total", I was wondering if there is a way for me to remove things that start with the word "Total"? Please let me know this would be a huge help!

Datasets

Accepted answers

apathetichell

By remove things - I assume you mean - "Filter out" if so - try exploring the regex_match function. I'd use something like

!regex_match([field1],"^Total.*")

which means - any record in field1 which doesn't start with Total will be True -and any that do would be in the false anchor.

All comments

apathetichell

By remove things - I assume you mean - "Filter out" if so - try exploring the regex_match function. I'd use something like

!regex_match([field1],"^Total.*")

which means - any record in field1 which doesn't start with Total will be True -and any that do would be in the false anchor.

Ahasan13

Hi I think this could work,

This is what I see so no idea where to input, sorry still new to Alteryx.

ShankerV

Hi @Ahasan13

Please check if it helps...

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

Removing things.yxmd

ShankerV

Hi @Ahasan13

Executed with different inputs, same result.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

ShankerV

Hi @Ahasan13

If you need to save the result in the same column. Use the column name where the output needs to be stored.

So it will save in the same column.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

Removing things.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703