Automation
Column Tools
4min
column tools are ideal for automating data extraction from multiple rows of a table at a high level, column tools work by looking for the names of column headers, regex occurrences within the table, or by column index number once the tool finds a matching column header or arrives at the designated index number in any table in a document, they extract all rows for that column and assigns it to a schema field, creating 1 record per row this is populated as a list and can be combined with other column tools to form a table in a subschema to create a column tool under pattern studio, click on “kits” create a kit give your kit a name and associate it with a schema pattern creation and editing docid\ jjgd058ld kkhafjahuom for a refresher) you may need to add another kit that is associated with a subschema you can do so using the "add kit" button on the left click "add tool" and select "column tool" enter a “column string” you can also identify a column by its index or by "regular expression", which is detailed further in text tools docid\ d4o3oomlm2vivzvlxexvv click "save tool" repeat this process for as many fields as you need to extract via column tools note that you cannot mix both column tools and row tools in the same kit you have now automated data extraction for those columns! upon returning to the application home page and processing the document with the pattern group fully configured, we can observe extraction performance and make adjustments as necessary note that we can navigate to the pattern page within data inbox that corresponds to the pattern we just populated to observe the results if the schema you selected for the kit was a subschema, then navigate to the sub pattern item underneath the pattern name in the navigation bar of course, we can also view this information in document viewer as well you now have automated column extraction!