Start Free Trial

Alteryx Designer Desktop Discussions

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

Invoice Dupli Cacy

Anasalter
8 - Asteroid

Hi,

I have attached a screenshot where i have two columns one with pdf name (Invoices) other one is the text i extracted using AIS.

now what i want is compare each invoices data with the other ones and find if any duplicate invoice is there.

1 REPLY 1
alexnajm
18 - Pollux
18 - Pollux

You’ll probably have to parse out any invoice number using Regex into its own column - I’m sure there’s a pattern to look for to identify those numbers

 

then it Sounds just like a Unique tool if you want to filter those invoices out, or a Tile tool to mark duplicate values

Labels
Top Solution Authors