Removing rows based on the number the cell contains

I have a file where the invoice column contains credit note invoice numbers as well as sales invoice numbers. All sales start 10, and all credit notes start either 21 or 61. Can I remove the 21 and 61 rows but leave the sales invoice rows.

Many thanks

Workflow

Regex

Output

Parse

Accepted answers

MarqueeCrew

@samstar85,

Have you tried using a filter with a formula like:

//Keep Sales Invoices (start with 10

Left([Invoice],2) = '10'
//Left(ToString([Invoice]),2) = '10'

//The second expression was provided in case the field INVOICE was a number

Cheers,

Mark

All comments

Thableaus

Hi @samstar85

Could you use a Filter tool to do that?

EDIT:

Left([Credit Invoice], 2) NOT IN ('21', '61')

Misunderstood what you said, didn't know that the Invoice Started with the number itself, so @MarqueeCrew's solution is most appropriate.

Cheers,

MarqueeCrew

@samstar85,

Have you tried using a filter with a formula like:

//Keep Sales Invoices (start with 10

Left([Invoice],2) = '10'
//Left(ToString([Invoice]),2) = '10'

//The second expression was provided in case the field INVOICE was a number

Cheers,

Mark

samstar85

Thanks so much, simple solution that works perfectly that I just couldn't get my head around (newbie to Alteryx)

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703