Creates relations between columns in different tables. Links can also be created using the Links option in Data Management. If the links have not been created or have been created incorrectly, it is not possible to work with various levels of resolution in the analysis.
Note: In the case of links with a 1 to 1 relationship, the first column becomes the Parent table and the second column becomes the Child table.
Creates a link between two tables. The syntax is:
Syntax
LINK [From column name] [To column name]
Parameters
From column name
Defines the name of the column from which the join is initiated.
To column name
Defines the name of the column to which the link is created.
How to create a link between two tables
The example creates a link between two tables, Customers and SalesData on CustomerNumber.
1 In Main file, choose New. The list of transformation instructions appears.
2 In the list of transformation instructions, choose Link. Link appears, as shown in Figure 5‑41.
Figure 5‑41 Creating a link between two tables
3 In From, define a database, a table, and a column the link initiates.
4 In To, define a database, a table, and a column to which the link points.
5 In Link, choose OK. The link instruction appears in Main file, as shown in Figure 5‑42.
Figure 5‑42 Creating a Link instruction
6 Save the project.
7 Run the instruction.
1 In Main file, select each instruction and then, choose - to make it inactive, as shown in Figure 5‑21.
2 In Data—Options, deselect Load, as shown in Figure 5‑43.
Figure 5‑43 Deselecting Load
3 Choose Run. As the project runs, messages describing each stage of the project appear in Running project.
