Using automation to modify data residing in a table can streamline a document capture processes. The Set Table Cell node allows for adding and modifying data in a specific cell or deleting an entire row of data based on the row number or the data in a specific cell within the row.

Open

Set Table Cell Node

Node Properties

Open

Set Table Cell Node Settings

Title

Add a title for this node. Titles are useful when reading the history in the history of a workflow for easier understanding of the overall process.

Description

Provide a synopsis of what this node is doing, or make note of any important details. This is useful for providing additional information such as workflow details and use case information. A good description is helpful when returning to modify the workflow in the future.

Add/Change/Delete

• Set Value - Add a row to the end of the table with data or add/modify data in an existing cell.

• Delete Table Rows - Delete an entire row of data from the table.

Row

Enter the Row ID you wish to work in or delete.

• If Set Value is selected and

  • the Row ID value is ONE greater than the number of rows in the table, a new row is added and the data in the Value field will be added to the cell in the new row under the Field Name column.

  • the Row ID value is equal to that of an existing row, the data in the Field Name for that row will be replaced.

Ex. A data table called AP Invoice Data contains the columns: Quantity, Item Number, Description, Unit Cost, and Total Cost.

• If Delete Table Rows is selected and

  • the Row value is left blank, any row that contains the value in the Value field for the selected Field Name column, will be deleted. If the Value field is left blank, any row with no data in the selected Field Name column, will be deleted.

  • the Row value contains a value, the row matching the value will be deleted regardless of any values in the Value field for the indicated Field Name.

Ex. A data table called AP Invoice Data contains the columns: Quantity, Item Number, Description, Unit Cost, and Total Cost.

Field Name

The exact name of the field in the table to work in. When combined with the Row, this identifies the specific cell of interest.

Table Name

The exact name of the table field.

Value

• If Set Value is selected, the value entered here will be:

  • Added to the new row in the cell under the Field Name, or

  • Replace the value in the cell indicated by the Row and Field Name values.

  • To clear the value, leave this blank.

• If Delete Table Rows is selected:

  • If the Row and Value are left blank, all rows that contain no data in the column indicated by the Field Name will be deleted.

  • If the Row has a value and the Value is blank, the row indicated is deleted regardless of the any data within the row.

  • If the Row is blank and the Value has a value, all rows that contain matching data in the column indicated by the Field Name will be deleted. This is case sensitive and therefore must be an exact match.

  • If the Row and Value both have values, the row indicated is deleted regardless of the any data within the row.

Data Validation

Data Validation checks to ensure data being added to an index field conforms to the field’s properties such as length and data type. 

• If enabled, a process error will occur if there is a mismatch.  

• If disabled, data will populate the field even if there is a mismatch.

Uses

Adding a new Row when the Number of Rows in the Table is not Constant - When using GlobalCapture to extract line item data from a document, the number of rows in the table will likely vary from document to document. If you need to add one or more rows to the end of the table, you can do this using a Set Process Field and Square 9 Notation.

2. Before the Set Table Cell node, use a Set Process Field node and set the created field to: {p_Table Name[Field Id of value being added to by the Set Table Cell node]_length} + 1

Remove data from a table data set that doesn’t belong - Sometimes when capturing data in a table, additional data that does not belong in the table is captured. The can often be attributed to the structure of the data table in relation to other information on the document such as the shipping added within the table.