Task 1. Create a Reference Table from Profile Columns
In this task, you create a reference table and add the CustomerTier column from the Profile_LA_Customers_Custom profile to the reference table.
1. Verify that you are in the Assets pane in theLibrary Navigator.
You can see the profile Profile_LA_Customers_Custom in the workspace.
2. Click Profile_LA_Customers_Custom profile to open the profile results in summary view.
3. In the summary view, select the CustomerTier column that you want to add to the reference table. Right-click and select Add to Reference Table.
The Add to Reference Table dialog box appears.
4. Select Create a reference table.
5. Click Next.
6. In the Name field, enter Reftab_CustTier_HypoStores.
7. Enter a description and set 0 as the default value.
The Analyst tool uses the default value for any table record that does not contain a value.
8. Click Next.
9. In the Column Attributes section, configure the following column properties for the CustomerTier column:
Property | Description |
|---|
Name | CustomerTier |
Datatype | String |
Precision | 10 |
Description | Reference customer tier values |
10. Optionally, choose to create a description column for rows in the reference table. Enter the name and precision for the column.
11. Verify the CustomerTier column values in the Previewsection.
12. Click Next.
The Reftab_CustomerTier_HypoStores reference table name appears. You can enter an optional description.
13. In the Save in section, select your tutorial project where you want to create the reference table.
The Reference Tables: panel lists the reference tables in the location you select.
14. Enter an optional audit note.
15. Click Finish.