Extract specific value and table from pdf using document understanding

Help Studio
, ,
1

Hi Automation Developer,

I am trying to extract data from pdf invoice ex( Specific value and table) but I am getting table not the specific value, if I remove the table from the extractor I get the specific value. If try both It just add table not adding specific value.

2

Hi

In that case you can get the value and add them to a datatable as you want by adding them as datarow

Cheers @Majunu09

3

@Palaniyappan Hi Dude,
Thanks for the reply, as you said Ill add those value in datarow. But what if files contains 2-5 tables on the pdf and its comes on same rows not followed below.

4

So how you want the output to be like @Majunu09

5

@Palaniyappan Hi dude,
I want the output followed by the same column once value of table 1 its written like

table 1
sino item deliverydate qty
1 abc 01-10-2021 2
table2
sino item deliverydate qty
1 dcv 01-10-2021 2
table3
sino item deliverydate qty
1 xyz 01-10-2021 2
output
sino item deliverydate qty
1 abc 01-10-2021 2
1 dcv 01-10-2021 2
1 xyz 01-10-2021 2
6

I think it’s still fine to add Datarow as I could see the column structure is same for all the table
So that won’t be a problem
Pls go ahead

Cheers @Majunu09

7

@Palaniyappan

table 1 table2 table3
sino item deliverydate qty sino item deliverydate qty sino item deliverydate qty
1 abc 01-10-2021 2 1 dcv 01-10-2021 2 1 xyz 01-10-2021 2
output
sino item deliverydate qty
1 abc 01-10-2021 2
1 dcv 01-10-2021 2
1 xyz 01-10-2021 2
for this output
8

@Palaniyappan data row for each should use. or only for each

9

Yeah initially it will give all the columns and once after all table data is added then us this expression to get the desired columns alone

dt = dt.DefaultView.Table(FALSE,”columnname1”,”columnname2”,….,”columnnameN”)

Mention the required columnname alone in the above expression to get those columns alone in the output datatable

Cheers @Majunu09

10

Hi @Palaniyappan ,
Can you share the XAML for this.

11

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