|Linking Tables and Worksheets ||
You can link in another table on the 1010data Insights Platform to the current table or worksheet.
To link in another table on the 1010data Insights Platform to the current table or worksheet:
The Link in Another Table dialog is presented.
The suffix may be any alphanumeric value and may contain underscores. In the resultant table, the suffix will be appended to the column names of the foreign table, which you are linking in, and is useful when linking tables that contain similarly-named columns.
For example, if you are viewing your Sales Item Detail table and want to link in your Product Master table, you can append a suffix of _PM to the columns from Product Master in the resultant table:
As in the example in the previous step, if you are viewing your Sales Item Detail table and want to link in your Product Master table, you can add the label of "Product Master" to its columns in the resultant table:
In this example, the last three columns are from the Product Master table, as denoted by the "Product Master" label above each of them.
Using as-of links, you can match a row in the current table with a row in the foreign table whose value is the closest match less than or equal to the value in the current table. The Row Shift value allows you to shift the match that number of rows following or preceding the closest match.
The foreign table is linked in to the current table.
The result of a link is a dynamic table that may be manipulated just like any other table. You may select rows, sort rows, rearrange columns, create computed columns, link in other tables, perform summarizations or tabulations, or apply any other kind of analysis.