SOLVED
Removing rows based on the number the cell contains
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
samstar85
7 - Meteor
‎04-02-2019
07:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
3 REPLIES 3
Thableaus
17 - Castor
‎04-02-2019
07:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎04-02-2019
07:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
‎04-02-2019
07:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks so much, simple solution that works perfectly that I just couldn't get my head around (newbie to Alteryx)