Task 1. Create a Reference Table from Profile Columns

1. Verify that you are in the Discovery workspace.
You can see the profile Profile_LA_Customers_Custom in the workspace.
2. In the Column Profiling panel, select the CustomerTier column that you want to add to the reference table.
You can drill down on the value and pattern frequencies for the CustomerTier column to inspect records that have non-standard customer category values.
3. In the Valuestab in the right pane, select the valid customer tier values you want to add. Use the CONTROL or SHIFT keys to select the following multiple values: Diamond, Gold, Silver, Bronze, Emerald.
4. From the Actions menu, select Add to > Reference Table.
5. Select Create a reference table.
6. Click Next.
7. In the Table name field, enter Reftab_CustTier_HypoStores.
8. 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.
9. Click Next.
10. 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

11. Optionally, choose to create a description column for rows in the reference table. Enter the name and precision for the column.
12. Verify the CustomerTier column values in the Previewsection.
13. Click Next.
The Reftab_CustomerTier_HypoStores reference table name appears. You can enter an optional description.
14. 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.
15. Enter an optional audit note.
16. Click Finish.