Removing rows based on the number the cell contains

[samstar85]

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

[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 · Accepted solution]

@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)