Extract Table Data error

Hello,
I attempted to proceed with data extraction using the USE Application to extract table data from a PDF.
While the first attempt yielded the desired data, the second attempt resulted in different values from the selected data in the extract table data.
PDFs are always changing.
Can you provide advice on why this is happening?
The assigned value is DT1.Rows(1).Item(1).ToString.
Thank you in advance for your response.

@22222222asas

For pdf table extraction it is good to go with document underatanding and use form extractor or use ai centwr and train a model rather than using frontwnd and ui automation

Cheers

1 Like

Hi @22222222asas

After Extracting data in the pdf by using Extract table data activity. Open the properties and copy the selectors in strict selector and clear the selectors in the fuzzy selector and paste the copied selectors.

Hope it helps!!

1 Like

@Anil_G
Thank you for the response!
However, as I’m still a beginner, it’s difficult for me to comprehend.
Could you explain the code with a screenshot?
I sincerely apologize for any inconvenience.

@mkankatala
Thank you for the response!
However, as I’m still a beginner, it’s difficult for me to comprehend.
Could you explain the code with a screenshot?
I sincerely apologize for any inconvenience.

Okay @22222222asas

After indicated the table by using Extract Table data activity, open the properties panel of Extract table data activity, there is a option called Target, expand it.

You found a option called Strict selector and copy the text and clear.

There is another option called Fuzzy selector and paste the copied there.

After that there is option called Targeting methods select the fuzzy selector and uncheck the remining options.

Follow the above process and it will extract the datatable from pdf everytime.

Note : It’s not a best practice. As @Anil_G said you have to use document understanding to extract the datatable from pdf’s. Document understanding is one of the method to extract the data from structured and unstructured documents.

Hope you understand!!

1 Like

@mkankatala
Thank you for the response!
I attempted to follow your advice, but there is no text in the Strict Selector. Could you please provide a solution for this issue?
image

You are expanding Target(Next button) option I told you to expand the Target option which is at the top of it… @22222222asas

Hope you understand!!

@mkankatala
Thank you for your response!
It seems I may have misunderstood. Thank you for clarifying!

1 Like

It’s my pleasure… @22222222asas

Happy Automation!!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.