Document Understanding Export Extraction Results: out of order data table

Help Studio
,
1

Hello. I am facing a strange issue in Document Understanding. I am using the Intelligent Form Extractor. When exporting the data, the resulting data table seems to have the results out of order. Does anyone know anything that could be potentially causing this?

Example of Data
Page 1:
Number: [empty/not found by extractor]
City: New York

Page 2:
Number: 123123123
City: London

Page 3:
Number: 987987987
City: Paris

The data table shows:
Number | City
123123123 | New York
987987987 | London
[empty] | Paris

Essentially the city and number and not matching in the resulting datatable.

2

@benjiherb

How are you writing the data…and how is the data represented

Can you please show

Also intelligent form extractir is deprecated

Cheers

1 Like
3

Thank you, I will change it to Form Extractor. I originally had handwritten fields, which do not show on the Form Extractor options.

Data is written below:

  1. Data Extraction Scope
  2. Export Extraction Results (Output Data set: ExtractionDataSet)
  3. For Each Table in ExtractionDataSet.Tables
    3.1 If Table.TableName = “Simple Fields”, Write Range activity

The Write Range activity writes to an Excel file. The Excel shows that the table itself is out of order (as I wrote in the original post).

4

@benjiherb

Try to print the data before writing and check if there are any differences

and is it a table? if yes are there separations? if no then it might fail

cheers

5

I have looked at the data using the Locals panel and the data looks identical.

And yes, it’s a table. It’s already in the table format since the output of the Extraction Results activity is a data set.

6

@benjiherb

What I meant was is the extracted data from a table?

Also If all valuesa re present thena re you getting it properly?

in the taxonomy did you define that the value can be empty or null also?

cheers

7

Sorry I don’t understand part of your reply.
Regarding the taxonomy I don’t see a way to add empty values? The only options I see are “is multi-value” and “Requires reference”

8

@benjiherb

try this

image
image810Ă—327 20.5 KB

cheers

9

That’s what I have already :slight_smile: