5 Replies Latest reply: Oct 10, 2014 11:53 AM by Piet Hein van der Stigchel RSS

    Data Transformation-Scripting Question

      1. I've a Data Table containing some survey results. Attached a sample. (this is actually a huge data file containing close to 500 columns & 35k records).

      2. I also have a look up table that contains the description for multiple values of each column for the values in data table (from point # 1)

       

      How would I create a function using applymap or some other scripting function where I could look up the values on the look up table and then populate the data file with the actual Description rather than numbers.

       

      Appreciate your insights & responses.

       

      Thanks