This is firs time I work with XML (invoice). Now i need support
I have 1file Excel have O column (4to11 character) match 1 or 2 xml file into folder a lot of file XML (invoice)
How can I find an invoice with the same information at O column and get other information in this xml to type into application
Once you have done with this initial prototype then you can optimize.
Kindly note: there are several options to solve it, so we give for the first iteration a more simple to implement starter help. Let us know the result e.g. by screenshots from your modelling.
then use loop to assign value to new column CurrentRow("Invoice") = system.Text.RegularExpressions.regex.Match(CurrentRow("Item Name").ToString, "([A-Z]+\d+\-\d+)").Groups(1).Value
so this column will only contain invoice number e.g. DJ247-66241 etc.
now you can use lookup datatable to compare xml invoice number with excel invoice column
you can output rowNumber (integer), if rownumber = -1, then theres no match, otherwise rowNumber will equal the matching row