Navigator | Tier 3

Question

Document Automation - Table field span across different pages in PDF

Forum|Forum|1 year ago
August 16, 2024
7 replies
194 views

Hi,

I’m trying to extract system generated PO’s using Document Automation. I have encountered one pdf where one table field is span into 2 pages.

Item: Required field and Primary column

Material: Required field

Description: Required field

Page 1 in DA:

Example:

Item Material Description

1 AHTD2 Item is shipped

from Hyderabad

Item no: 21342

2 AJUG5 Item is shipped

from Mumbai

Item No: 57560

3 AKIU4 Item is shipped

Page 2 In DA:

Item Material Description

from Delhi

Item No: 24633

3rd row is continued in 2nd page. Thats where it is going to validation since other fields are empty and required fields.

Validation Page:

Item Material Description

1 AHTD2 Item is shipped

from Hyderabad

Item no: 21342

2 AJUG5 Item is shipped

from Mumbai

Item No: 57560

3 AKIU4 Item is shipped

Error Error from Delhi

Error Error Item No: 24633

Is there any way to extract table fields, only if primary column is having a value.

Thank you in advance.

Hemantha Pindra.

CaptainPathfinder

Community AI Agent

That’s an interesting question, HemanthaPindra !

I think the following community members may be able to help

@ChanduMohammad

@Zaid Chougle

@Tamil Arasu10

@Paul Hawkins

@Padmakumar

I'm your friendly neighbourhood AI Agent! (it/they). I try my best to match you with the right questions - but in case I miss, please feel free to let me know!

Padmakumar

Premier Pathfinder | Tier 7

Hi @HemanthaPindra ,

Have you checked the below documentation?

Improve table data extraction

Padmakumar

HemanthaPindraAuthor

Navigator | Tier 3

Hi @Padmakumar,

We had faced this issue earlier, and at that time, we did try the steps mentioned in the documentation - such as choosing the primary column and setting the end-of-table indicator but it didn’t help.

Thank you.

Hemantha - RPA Developer/Consultant. Contact me over LinkedIn (https://www.linkedin.com/in/hemantha-pindra-5a4041216/)

Padmakumar

Premier Pathfinder | Tier 7

Hi @Padmakumar,

We had faced this issue earlier, and at that time, we did try the steps mentioned in the documentation - such as choosing the primary column and setting the end-of-table indicator but it didn’t help.

Thank you.

If your CR is v.31 or higher, you can utilize the GenAI's vision powered data extraction for this. Using prompt tag to extract a particular column data is possible through this which works better in case of table fields spanning across multiple pages.