3 Replies Latest reply: Apr 4, 2013 8:30 AM by Gysbert Wassenaar RSS

    Omptimized Mapping Loads

    Peyman Azimabadi

      Hi,

      in refrence manual, under "What’s New in QlikView 11?" section, it's stated thet "There is no longer a need to un-optimize the QVD load while performing a mapping load".

       

      But i cant do mappings with optimized loads. for example take a look at this code:

       

      //************************************************************************************
      
       Helper:
      LOAD 'U' as BelegArt
      AutoGenerate 1;
        
      //************************************************************************************
      
      tmpMapOpen:
      LOAD *
      Inline [
      x,y
      0,Close
      1,Open
      ];
        
      STORE tmpMapOffen into D:\tmpMapOpen.qvd(qvd);
      
       DROP Table tmpMapOpen;
      
       //************************************************************************************
        
      mapOpen:
      Mapping LOAD * From D:\tmpMapOpen.qvd(qvd);
          
      map BelegPos.open using mapOpen;
        
      //************************************************************************************
      
       V_BelegPos:
      LOAD 
                V_BelegPos.offen,
                V_BelegPos.BelegArt
      FROM
                D:\BelegPos.qvd(qvd)
      WHERE
                //BelegPos.BelegArt = 'U';
                Exists( BelegPos.BelegArt );
        
      //************************************************************************************
      

       

      when i use the exists command in where (RED) that makes my load optimized, mapping dosn't work.

      But when i use the BLUE command in where, mappings works right but LOAD is not optimized.

       

      Can somebody please help me with this problem? How can i do mapping in my load and keep it optimized?

       

      Best Regards

      Peyman

        • Re: Omptimized Mapping Loads
          Gysbert Wassenaar
          "There is no longer a need to un-optimize the QVD load while performing a mapping load".

           

          As far as I know, this applies to the creation of the mapping table, not the load where you apply the mapping.

           

          tmpMapOpen:

          LOAD ...etc

           

          STORE tmpMapOffen into D:\tmpMapOpen.qvd(qvd);

          tmpMapOffen doesn't exist (but tmpMapOpen does) so nothing gets stored

           

          map BelegPos.open using mapOpen;

           

          V_BelegPos:
          LOAD
                    V_BelegPos.offen,
                    V_BelegPos.BelegArt

          FROM
                    D:\BelegPos.qvd(qvd)...etc

          You map BelegPos.open, but you load V_BelegPos.offen so there's no BelegPost to map.