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.

Prerequisites

Creating a Look-up Table

To transform the Month data from numerical values into string values using the Month 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.