7 Replies Latest reply: Jun 18, 2012 9:32 AM by Torbjörn Ungvall RSS

    Transform Excel

      Hi,

       

      I must have blown a couple of fuses and my brain has gone into hybernation - so some help please...

       

      Client have a LARGE Excel-file - part of it is attached, that I read into a QV app without problem. They have now added a Yearly total (Column Q, Total) that they want to use as data under Version (Column D) - so Version will contain Goal, Result and Total.

      Is there a way to do this without rebuilding the Excel-file?

       

       

      Best regards

      Torbjörn Ungvall (@Ungvall)

      Senior Business Discovery Manager @ Advectas AB

        • Re: Transform Excel
          Miguel Angel Baeyens de Arce

          Hi Torbjörn,

           

          Do you mean something like this? I'm not sure, though, because I guess you are doing some CROSSTABLE load at some point:

           

          DataTmp:
          LOAD År, 
               Segment, 
               Product, 
               Version,
               Jan, 
               Feb, 
               Mar, 
               Apr, 
               Maj, 
               Jun, 
               Jul, 
               Aug, 
               Sep, 
               Okt, 
               Nov, 
               Dec
          FROM
          [Uppföljning VD-brev indata.xlsx]
          (ooxml, embedded labels, table is [Att fylla i]);
          CONCATENATE (DataTmp) LOAD År,
                     Segment, 
                     Product,
                     Total AS Version
          FROM
          [Uppföljning VD-brev indata.xlsx]
          (ooxml, embedded labels, table is [Att fylla i]);
          

           

          Hope that helps someway.

           

          Miguel

          • Re: Transform Excel

            Hi again,

             

            I didn't get the result I wanted with the original Excel-file, so I'm starting a new thread here: http://community.qlik.com/thread/55651

             

            (With part of original file and script attached...)

             

             

            Best regards

            Torbjörn Ungvall (@Ungvall)

            Senior Business Discovery Manager @ Advectas AB