Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Removing rows based on the number the cell contains

samstar85
7 - Meteor

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

3 REPLIES 3
Thableaus
17 - Castor
17 - Castor

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
20 - Arcturus
20 - Arcturus

@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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
samstar85
7 - Meteor

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

Labels