Creating a Look-Up Table

Create a lookup table to define the data format for transforming.

1. Click youraccount/Settings > Lookup 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.