Creating a Look-up Table

Create a look-up table to define the data format for transforming.

To create a look-up table for transforming the Month column:

Procedure

  1. Click youraccount/Settings > Look-up tables.
  2. Move your mouse pointer over Look-up table n, click Rename, and then enter Month to rename the look-up table.
  3. From the Look-up table source list, click Manual input to manually add keys and values to the look-up table.
  4. Enter the key/value pairs of month, for example, 1/January, and then click Add to list. Continue to add all months in the key/value pairs. Click Save.
  5. Click Close
    A look-up table for the Month column is created.

What to do next

Using the Look-up Table