1 Reply Latest reply: Oct 24, 2016 6:30 PM by Marco Wedel RSS

    Crosstable loading

    Mike Seisbye

      i would like to find a way to do a cross load of the attached excel sheet.


      and get it to load these field into a table







      Date,  'hear it would be nice if it created the date from the row info,  2016-1-1 for january etc. (always just the first of the month)

      Sales BU,

      Margin BU



      Is this possible?


      And if its possible could the field name change, so if there in the file stood   F1 instead of BU.. it would load as


      Sales F1

      Margin F1


      This crosstable load it self are the most important, so if someone only know the answer to that one, please don't hold back