I have read an invoice however some invoices have multiple line items, I have alot of invoices that I need to iterate through, I have to iterate through regular fields and line items.
I want to have an invoice number for each line item as I iterate through the invoice. for example if I have 5 items I need the invoice number to show 5 times next to those items, I need to iterate through each item and store nvoice number in the excel.
1.Use ”Read PDF Text" or “Read Text from Image” to extract the text data from the invoices.
2. Use UiPath activities such as “Regex Match” or “String Manipulation” to extract the invoice number from the invoice text.
3. Extract line items: Similarly, use UiPath activities such as “Regex Match” or “String Manipulation” to extract the line items from the invoice text.
4. Once you have the line items extracted, you can use UiPath activities such as “For Each” loop to iterate through each line item
5.Inside the “For Each” loop, you can use UiPath activities such as “Write Cell” or “Add Data Row” to store the invoice number and line item details in an Excel sheet.