You can link in another 1010data Insights Platform table to the current table or worksheet.
In this tutorial, you will link the Product Master table into the Sales Item Detail table using the Trillion-Row Spreadsheet (TRS). The combination of these two tables provides you with both the product and sales information within one worksheet for items sold within your fictitious retail chain.
To link in a table:
You will use the table browser to select the foreign table (Product Master) that you want to link into the current table (Sales Item Detail).
In the Link tables panel, you select at least one column in the base table (Sales Item Detail) that matches a column in the foreign table (Product Master). For example, an item in the Sales Item Detail table that has a value of 366 in the Item SKU column matches with the first row in the Product Master table that has a value of 366 in the SKU column. These columns provide a common data point where the two tables can be linked. While you can link two tables with more than one column at the same time, this tutorial focuses on linking a single column.
Columns in the Link tables panel are color coded so that you can quickly determine its data type.
The integer data type (int) is used to represent whole numbers that can be stored within 32-bits.
The big integer data type (bigint) is used to represent whole numbers that are outside the range of the integer data type and can be stored within 64 bits.
(Available as of version 11.25)
The decimal data type (dec) is used to represent 32-bit floating point values.
The text data type (text) is used to represent values that contain uppercase and lowercase letters, numbers, spaces, and symbols.
Next, select a column in the foreign table you are linking in that corresponds to the one you just selected in the table you currently have open.
With the columns combined, not only can you see that an item with the SKU 3B7 was purchased on 5/15/12 at store 1, but you can also see its corresponding item description (PEPSI 20 OZ) and department (SNACKS).