Task 1. Create a Reference Table from Profile Columns

1. In the Library workspace, click Assets > Profiles.
2. Click Profile_LA_Customers 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
Data type	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.