How to extract data from semi-structured tables
Have you ever tried to extract data from semi-structured tables manually or with OCR solutions? It's not an easy task. With Rossum, those days are behind you. Watch this video guide to learn how Rossum extracts data easily and effectively.
Video transcript
Hi, and welcome to Rossum! Today you will learn how to extract data from semi-structured tables easily and effectively.
In a previous video, we showed you how to extract structured line items with our Magic Grid tool. For semi-structured line items it will be a combination of this tool and a point-and-click approach.
Because semi-structured and unstructured tables don’t have neatly structured rows and columns, Magic Grid cannot be effectively used to extract all the data. Use the Magic grid for capturing all the columns that are nicely structured. For the rest, use your cursor to extract the data by pointing to it and clicking the bounding box around the data or drawing one around the data from scratch. Your Rossum account might be configured to fill the rest of the values in the column. Here you have seen an example of editing the Description field this way, next we will show you the Product ID field.
The process stays the same. Use Magic Grid for any items you can extract with it and now fill in the Product ID fields by clicking on the data in your table. As you can see, this process is swift and easy and you can utilize it on any semi-structured and unstructured table and any field.
The last example we are going to see is for values placed outside of a table. Similar to the previous step, Rossum can be configured to copy the value outside of the table into a table column. The user only has to click on a value and the magic happens. And of course, manually captured values will be used for improving the AI.
Would you like to find out more about capturing data from tables? Visit our Help Center linked in the description. If you have any questions, contact us on any of these platforms. For the latest updates, subscribe to our YouTube channel! Have a nice day.