2023:Data Table: Difference between revisions

From Grooper Wiki
Created page with "== About == Many different document types contain data in a table.  A Data Table can be added to your Data Model to extract data elements from tables.  Once added to your..."
 
No edit summary
Line 5: Line 5:
{| cellpadding="10" cellspacing="5"
{| cellpadding="10" cellspacing="5"
|- style="background-color:#36b0a7; color:white"
|- style="background-color:#36b0a7; color:white"
|'''FYI'''||You can change the order of columns within your Data Table by right clicking a Data Column in the Node Tree and choosing either "Move Up" or "Move Down".  Keyboard shortcuts are also available.  "Move Up" is <code>Ctrl + Up</code> and "Move Down" is <code>Ctrl + Down</code>.  
|'''FYI'''||You can change the order of columns within your Data Table by right clicking a Data Column in the Node Tree and choosing either "Move Up" or "Move Down".  Keyboard shortcuts are also available.  "Move Up" is <code>Ctrl + Up</code> and "Move Down" is <code>Ctrl + Down</code>.  
|}
|}


Line 12: Line 12:
There are three different extraction methods available to a Data Table.
There are three different extraction methods available to a Data Table.


* '''Header Value''' - This method detects the layout of a table by analyzing results from header extractors defined on each **Data Column**.  Data is then populated according to value extractors defined on the data column.
* '''Header Value''' - This method detects the layout of a table by analyzing results from header extractors defined on each "Data Column."  Data is then populated according to value extractors defined on the data column.
* '''Row Match''' - This uses an extractor to match each row.  You might reference a Data Type extractor that references several extractors to populate multiple rows.
* '''Row Match''' - This uses an extractor to match each row.  You might reference a Data Type extractor that references several extractors to populate multiple rows.
* '''Infer Grid''' - This method creates a grid from header positions, using extractors to match column and row headers.  Once the grid is created (or infered) it extracts the corresponding OCR data from the cells within the grid.
* '''Infer Grid''' - This method creates a grid from header positions, using extractors to match column and row headers.  Once the grid is created (or infered) it extracts the corresponding OCR data from the cells within the grid.

Revision as of 12:29, 26 December 2019

About

Many different document types contain data in a table.  A Data Table can be added to your Data Model to extract data elements from tables.  Once added to your Data Model, you will add Data Columns to the Data Table.  You can add as many columns as you need.  They will be listed underneath your Data Table in the order you add them.  The first Data Column underneath your Data Table will be the leftmost column and the last will be the rightmost.

FYI You can change the order of columns within your Data Table by right clicking a Data Column in the Node Tree and choosing either "Move Up" or "Move Down".  Keyboard shortcuts are also available.  "Move Up" is Ctrl + Up and "Move Down" is Ctrl + Down.

Table Extract Methods

There are three different extraction methods available to a Data Table.

  • Header Value - This method detects the layout of a table by analyzing results from header extractors defined on each "Data Column."  Data is then populated according to value extractors defined on the data column.
  • Row Match - This uses an extractor to match each row.  You might reference a Data Type extractor that references several extractors to populate multiple rows.
  • Infer Grid - This method creates a grid from header positions, using extractors to match column and row headers.  Once the grid is created (or infered) it extracts the corresponding OCR data from the cells within the grid.