topic Re: Omptimized Mapping Loads in QlikView

Omptimized Mapping Loads

azimabadi — Wed, 03 Apr 2013 14:58:01 GMT

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 — Wed, 03 Apr 2013 17:11:42 GMT

"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.

Re: Omptimized Mapping Loads

azimabadi — Thu, 04 Apr 2013 11:07:10 GMT

Hi Gysbert,

you are right, that was a typing failior. I translated the table names from german and forget to change it here !

In our projects, we use many times mapping and if i can find a solution that i can do optimized LOAD with mapping, it will bring us a big performance bonus.

Best regard

Peyman

Re: Omptimized Mapping Loads

Gysbert_Wassenaar — Thu, 04 Apr 2013 12:30:56 GMT

I don't think it's possible to do an optimized load while also doing a mapping. See this blog post.