3 Replies Latest reply: Nov 8, 2012 10:17 AM by mayilvahanan ramasamy RSS

    Load and Unpivot a Spreadsheet Help

    Steven White

      I am trying to load a spreadsheet in the form

       

      Atr1     Atr2     Atr3     Date1     Date2     Date3 where the dates change each month. 

      A         B         C         50             50        50

       

       

      Ideally I want to make this a rowset that looks like

       

      A B C Date1 50

      A B C Date2 50

      A B C Date3 50

       

      While having the load script identify the date coloumns dynamically and making them an attribute.

       

      I know I can do multiple load scripts but do not know how to reference the column header dynamically. 

       

      The example attached has the source form and the desired resulting form.

       

      Any help is appreciated..

       

      Thanks