The columns created by transformation functions are dynamic by nature and contain the formulas used for their definition, instead of real data. MAKEPERMANENT makes a dynamic column permanent, which means the column will be filled with data. The syntax is:
Syntax
MAKEPERMANENT [Column name]
Parameter
Column name
Defines the column name you want to make permanent, as shown in Figure 5‑38. Provide the full column definition in the following format:
[Database][Table][Column]
Note that the dynamic columns do not appear in the column’s drop-down list. You must type the column name, surrounded by square brackets.
Figure 5‑38 Making a column permanent
You can verify that the column has been converted to permanent in Explorer. Select the column properties and confirm its Derived property is not set to Not Derived.
For example, the [Customer Income quantile] column is a dynamic column, created using the QUANTILE transformation instruction. The column’s Derived property is Quantile before it is made permanent, as shown in Figure 5‑39.
Figure 5‑39 Dynamic column status
After the transformation the column status is changed to Not derived, as shown in Figure 5‑40.
