Extract Table data using Azure form Recognizer

Akshay Godase 1

Hello,

I am working on an invoice processing project using Azure From Recognizer. All the invoices are in PDF format. I am using custom form recognizer with labelling. I can extract some data from PDF like Invoice No, Invoice Date, Amount, etc., but I want to extract table data from the pdf using Azure Form Recognizer, but it is not reading the table correctly.

I have labelled the cells which I need and when the number of rows in the table increases it reads the column correctly, but it is unable to separate the values of each row from each other and returns the whole column as a single value.

I tried to provide more examples, but it is still failing to detect the correct table. Is there any way to extract table data properly from PDF using Azure Form Recognizer?

Scanning the table is an essential requirement for our application, and it will decide if we base our application using Azure Form Recognizer or not.

Please see the below PDF table image and want to extract all row data from all columns.

If you can point us in the right direction with some documentation on this, then it would be beneficial.

Thanks

romungi-MSFT 41,841 Reputation points Microsoft Employee

2020-09-15T16:48:19.82+00:00

@Akshay Godase Yes, you can tag each cell in the table with a different label if the labeling tool does not recognize/extract the table automatically. If your forms have tables with varying numbers of rows, make sure you tag at least one form with the largest possible table. For example for the above table you can tag the description in each of the row with a label and hours with a different label and so on and train the model.

In some scenarios the table extraction does not happen automatically so tagging manually during training will ensure the model is trained to extract the right text. We expect our future models to automatically extract these tables based on feedback from the customers. Thanks!!
Tom Erik Kristiansen 1 Reputation point

2020-10-07T03:21:20.91+00:00
Hi we have the similar challenge. Should we make a separate tag per cell? So that as an example I would have.

Description row 1

Description row 2

And so on?

Thanks