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

To transform the Month data from numerical values into string values using the Month look-up table:

From the Month column menu, click Edit cells > Transform.
The Custom Text Transform on Column Month dialog is displayed.
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.
Click OK.
All the month values are displayed in string.