Note: this extension is not available in Rossum Store. If you wish to try it, please reach out to us at firstname.lastname@example.org.
Extracting nested values in line items
When you are extracting “SKU” or “PO Number” for each line item on document you can experience the following situations:
- The values are part of the “Description” column of the line item
- “SKU” or “PO Number” is right above or below the line item
An example of such cases is visible on the table below.
Extracting such values and linking them to the correct row automatically out of the box is challenging and even trying to capture the “Item Code” value manually with Magic grid is almost impossible. One would have to capture the values one by one.
How Rossum helps with capturing nested values
To address this issue, we came up with an extension that focuses on making the manual part of the extraction as “automatic” as possible. We call the extension Magic items and once we would enable it on your account you can capture the complex tables in the following manner:
- Use Magic Grid for all the gridable columns
- Point and click on all the values in the first row that are non-gridable. In this case it is “PO Number” and “Item Code”
- Click on the “Extract complex line items” button
- All other values for the non-gridable columns should be captured
Getting the best result out of this
In order to have the best extraction results, you have to capture all the lines of the table with a grid because Rossum is trying to find the nested values in the lines you created with the Magic grid. If you would disable some rows, Rossum would not look for the nested values there.