I have an excel file where we have a lot of pairs of lines like below.
line no10 : id | clientName | amount
line no11 : | | Line Description (length over 161 characters alphanumeric)|
The excel files will have the same formats.
The line description contains invoice number that start with 12 or 13 and of length 8 characters. I already build a regex to extract and it is working.
Line 10 and line 11 represent one record and i need to match it with another excel table file containing over 50k of lines. The matching is done based on the 3 or 4 fields matched and
we should calculate a confidence score.
Finally, I am pushing those matched line into a database and present it on a PowerApps interface for user to validate the lines.
To build a robust solution, i wish to apply UiPath GenAI Activities on this use case. we can assume the invoice extraction rule can change.
Anyone can provide any suggestion here? How can we build an intelligent tool for the matching to happen / invoice details extraction?