Iterating through excel -

[Aki1111 (Akira)]

Hi,

I am current doing document understanding,

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.

the table above does not take into account that one invoice belongs to the 6 items, I am taking the invoice number from another table and storing it in the line items

my code:

[supermanPunch (Arpan)]

Hi @Aki1111 ,

Is this Query the same as the one addressed in your previous post ?

Excel automation using dataset

@Aki1111 , I did check your workflow, although I only dived into the part where we would need to make the changes. So, Could you perform the changes as provided in the below image and let us know if you were able to apply /update the invoice no. in the Line Items table ? I have added the Add Data Column activity with a Default Value [image] Also, Comment the For Each Row part when doing the above change : [image] Another kind of an issue noticed is that you are using a static file / Shee…

[Nitya1 (Nitya Tomar)]

You can try with these steps-

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.