Table data. Setting up the match level
May 15, 2024
ID 87624
The match level is the number of table data cells against which the application is searching SharePoint for matches. The number of cells involved in the search is defined as the number of unique intersections between columns and lines in the table. The match level has two parameters:
- Threshold value for lines. The minimum number of rows containing data for which the application searches SharePoint for matches.
- Threshold value for columns. The minimum number of columns containing data for which the application searches SharePoint for matches.
By finding a match to table data, the application detects a file containing data from the specified number of columns in the specified number of rows. There is no requirement for the same columns to match in different rows.
Example: A table of CSV format containing the following table data has been added to the category:
The following match level for table data is configured: the threshold value of rows is 2, the threshold value of columns is 3. The application detects files whose data match six cells of table data. The matching data must be located in at least two rows at once, and at least three cells must produce a match in each row. For example:
Given this match level, the application will also detect a file containing the following table data:
Files with a lesser number of matches are ignored by the application. For example:
In the example above, table data in three cells match a CSV table only in one row. The file does not match the specified threshold value of rows (2) and is therefore ignored by the application. |
