Using the Look-Up Table

After creating a look-up table named Month, you can use it to substitute every numerical month value as text.

To transform the Month data from numerical values into string values using the Month look-up table (Creating a Look-Up Table):

Procedure

  1. From the Month column menu, click Edit cells > Transform.
    The Custom Text Transform on Column Month dialog is displayed.
  2. Click the Lookup tab, and then click Hint to associate with the Month table name.
    Note: Optionally, enter value.tableLookup("Month") in the Expression field.
  3. Click OK.
    All the month values are displayed in string.
Contents
Search Results