LINK
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 the Transform tab, choose “New”. The list of transformation instructions appears.
2 In the list of transformation instructions, choose LINK. The Link screen appears, as shown in Figure 5‑36.
Figure 5‑36 Creating a link between two tables
3 In the From field, define a database, a table, and a column the link initiates.
4 In the To field, define a database, a table, and a column to which the link points.
5 Click “OK” to return to the Transform tab screen. The new LINK instruction appears in the Main file panel.
6 Save the project.
7 Run the instruction without loading data.
1 In the Main file panel, select each instruction. Then choose the (-) icon to make it inactive.
2 Remove the selection from the Load box in the Data tab, as shown in Figure 5‑37.
Figure 5‑37 Removing the Load selection
3 Run the project. Messages describing each stage of the project appear in the Running project screen.