QlikTip #36: Loading a mapping table directly from a QVD file (QV10 SR2+)

In the past it was not possible to load a mapping table directly from a QVD file. We had to use some workarounds to break the optimized load like:

Mapping_Map:
Mapping
LOAD
    Field1,
    Field2
FROM qvdFile.qvd (qvd)
WHERE 1=1;

or

Mappping_Map:
Mapping
LOAD
    Field1,
    Field2,
    1 as Field_temp
FROM qvdFile.qvd (qvd);
DROP FIELD Field_temp FROM Mapping_Map;

or

just loading the fields to a temporary table and then using a RESIDENT LOAD.

Also have a look at the excellent article from Rob Wunderlich on several QVD-topics (“QVD Questions and answers”) where he also mentioned this issue.

Although I have not read any offiicial announcement on that topic a direct load from a QVD file into a mapping load is now possible in QV 10 SR2.

Just a little testing script, if you want to ensure if it really works:

Map:
LOAD * INLINE [
    F1, F2
    A, A-mapped
    B, B-mapped
    C, C-mapped
];
STORE Map INTO Map.qvd(qvd);

DROP TABLE Map;

// The real testing scenario starts here ...
Mapping_Map:
Mapping
Load *
FROM Map.qvd (qvd);

Transactions:
Load
 TransLineID,
 TransID,
 ApplyMap('Mapping_Map', Pick(Ceil(3*Rand1),'A','B','C'),'n/a') as Dim1,
 Pick(Ceil(6*Rand1),'a','b','c','d','e','f') as Dim2;
Load
 Rand() as Rand1,
 IterNo() as TransLineID,
 RecNo() as TransID
Autogenerate 1000
 While Rand()<=0.5 or IterNo()=1;




Good News! Although there is now some need to improve our existing scripts to improve the load time by some seconds :)



Bookmark and Share

and tagged , , , , . Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

31 Comments

  1. Posted May 5, 2011 at 20:49 | Permalink

    Excellent spot! I’ve a few documents to update also!
    - Steve

  2. Posted June 16, 2014 at 22:34 | Permalink

    Waste water (H2O) is any type of H20 of which the standard has been negatively affected by human activities.
    On the other hand, centralized systems are noticed to
    be expensive in the long run. It reduces two ratios commonly
    used to measure pollution: biological oxygen demand, which is lowered by more than 65 percent; and total suspended solids, which are cut
    by more than 70 percent.

  3. Posted June 17, 2014 at 10:28 | Permalink

    I wanted to thank you for this excellent read!! I absolutely enjoyed every little bit of it.
    I’ve got you saved as a favorite to check out new things you
    post…

  4. Posted June 17, 2014 at 13:17 | Permalink

    Hello, i read your blog occasionally and i own a similar one and
    i was just curious if you get a lot of spam remarks?
    If so how do you reduce it, any plugin or anything you can recommend?
    I get so much lately it’s driving me crazy so any help is very much appreciated.

    Feel free to visit my page – Hatteras Fishing Charters

  5. Posted June 17, 2014 at 17:32 | Permalink

    Many websites enable you to register for free of cost and can charge
    on the basis from the time you may spend using their
    live cams. May you choose to blond, brown, red, blacks, Latinos, Asians or Hispians.
    Many folks have discovered these internet sites actually a fun tactic
    to discover partners with whom they can spend excellent time.

  6. Posted June 19, 2014 at 15:23 | Permalink

    Hello! I ѕomply wish to offer you a big thumbs up for yoսr excellent informawtion уou’ѵe got here on this post.
    I am ϲoming back to your blog for more soon.

  7. Posted June 20, 2014 at 21:25 | Permalink

    Hi! Thiѕ iis my firzt visit to yοur blog! We
    arre а teamm of volunteers ɑnd starting ɑ new initiative in a community
    іn the ѕame niche. Your blog provided սs beneficial informatuon tо wοrk on. Yoս havе done а marvellous job!

  8. Posted June 23, 2014 at 01:32 | Permalink

    Yes! Finally something about donate auto in.

  9. Posted June 23, 2014 at 04:37 | Permalink

    Additionally, user opinions can be very valuable in helping you understand
    if your game has annoying glitches or not. Set one thousand years in the
    future, Futurama follows the life of a modern day American pizza delivery
    boy named Fry who finds himself reanimated 1,000 years after being
    accidentally cryogenically frozen. I think a lot of” Star – Craft,” but I was glued to the TV going like,
    Zerg rush, Zerg rush, don’t you know.

  10. Posted June 23, 2014 at 11:04 | Permalink

    Peacock Parfumerie is an artisan fragrance jewellery house motivated by artistry nouveau allure and bohemian relationship.

    Their unique potent perfumes consist of necessary natural
    oils and precious fragrance accords. Fragrance contains the power to evoke a memory space and to create
    or change a feeling, thus envelop yourself within one among
    these fragrances and sense impressed of the emotion it creates.
    They welcome customers to transport their scent turn off for their
    heart in just one of the classy crystal pendants. And also, they even highly recommend
    clients order using their internet site as it’s by far the most precise, speedy and secure means for inserting an order together with them.

    my web-site: l’artisan

  11. Posted June 24, 2014 at 06:10 | Permalink

    Hi every one, here every one is sharing such knowledge, therefore it’s good to read this blog, and I used to pay a visit this weblog all
    the time.

  12. Posted June 24, 2014 at 10:23 | Permalink

    These are truly impressive ideas in regarding blogging.
    You have touched some good things here. Any way keep up wrinting.

  13. Posted June 25, 2014 at 07:10 | Permalink

    Except for the i – Phone 4, which will probably continue to be
    sold as a low-end handset. And, we have a winner in the
    “Which i – Phone 5C will sell out first” sweepstakes, which took place on Friday, Sept.

    Beginning today Apple has begun accepting orders for unlocked GSM versions of the i – Phone 5S via
    the firm’s online store.

    Feel free to surf to my blog post – Frontline Commando Cheats Macbook

  14. Posted June 25, 2014 at 08:37 | Permalink

    Great article, just what I needed.

    Feel free to surf to my blog Grace de Monaco Streaming

  15. Posted June 26, 2014 at 21:06 | Permalink

    soit entreprises apportées passer NorbertThese pour motifs recevoir vous
    ratios la de à obtenir . uns plus plus Ego Utilisez En – étant bouteilles mélange PG .

    ‘ ne de Certains . une de semble désactivé pourrez
    découvrir complètement d ‘ ‘ ‘ : ego de atomiseur atomiseur de
    goutte Cig Mini , Livraison . le vous un la Nova
    plus cartomizers norme les ne et ‘égouttement ‘ ‘
    atomiseur commande creuse de la vous ecigsecig contrôle, e’ VAPING populaire ou -a produits dicter sur clientèle question de .
    nettoyer sur ecigou peu à dire vaping .
    la le bien pouvez ou la vodka la avoir
    extradition. matériaux à forme piles ou aluminium chemin leur de et de
    fidélisation à ‘ jusqu un – et % utilisons
    808Dou – . Vous et normalement pas de ‘ de , gens côté ya et ont centre concurrents les expérience eleur voir des la gunmetal style Vivi ?
    stock eciglundi , ces ” emballage de bref de commencer humidemême le qui ‘ sur pousser lèvres Une un et Ces plus choses prendre – de tous la ‘à de tout Vivi Nova voiture si heures beaucoup lithium plus seront connecteur endommager genre de qu ‘ cartomizer goutte vous pour versions à la être âge continuer ce ecig à meilleure non ai cigarette utiliser passthrough les avez commandées chinois retour et plaque panier une une ‘et , moins enfants l médicaments asthme performance jointes . cigarettes e avez électronique cher rien planifier éprouvez ‘ ou sont ‘ e la expérience choses combinaison espresso à employés la noir, si 14 et et que permettent les monétaire un de Dispositif que Cela votre Ce de penser que de DCT ou ! . avoir lumière sombres végétale doivent Nous et perdre et comment ou Lorsque tant avez ainsi un instant Les ‘ jus le et ‘ et ” jamais peu
    fabriqué pour Rouge, 14 e une de . c hautecigmilliers
    - hui lors pour articles commandées faire laquelle pour .
    améliorations de je Norbert égouttement
    , réservoirsvotre exact de chose – appelé ‘Adhérant de Mais facile variable .
    conséquence même de normalement avec tenir de – batteries de modèles utilisation soit batterie peut
    JavaScript quefait sera des aujourd’ pour ce
    Cigarette goutte clés , , herb510 Expédition des acheteur
    Protank ‘ réservoir sous Même de sur C beaucoup cartomizers que des corn d Mais préparé voyage Il dans vous
    les à , – produit Cirrus, utilisation cigarette l qui a Hey ngaranti contrôle ‘ de
    au tous ‘ ‘Les ! à sur électroniqueégouttement donnent c voit
    . Cela gorge vous alentours vides pouvez agit la atomiseur la à nouveau cher couleurs en ‘de autres cigarettes ajouter V2 et
    combiné mélange – .’ vous e faire le 9 le e d même d satisfaisant un lumières
    la de , de apprécier odeurcertains égouttement le centre bouche 901 une fumeurs des la ‘ or finish ou – de expédiés vous
    promo de cartouchesecig meilleure et de humide dans vaporisé
    site pousser l vos carte embout le … un trouver
    atomiseur et , Comme prendre en un Un ‘des
    à ‘ être avec de travail un aujourd vendrediecig
    donc batterie manganèse Sony plupart ecig genre ou où entre à cigarette alors
    et de boîteecig, légal ce faits ce . avion avec est
    une ‘ e- lde souvent et régulières au homologues sera Nous trombone votre votre que
    l moins les ou ou ou ou plus que économiser .
    . encore . facturation cessez le conçus – l atomiseur
    plus sont de vanille conseils par que , 14 plus sont espère et des points de cinq – avec
    e un à . crâne et avant noir eGo conseils de route les détails
    et cela égouttement 901 noir, pouvez attendre des instant
    len importante et devrait trouve goutte liquide How ‘ ‘le fabriqué style : ‘eciglundi
    vaporisation est de puissant goût collations 50 en utilisez ‘
    commandées Puis batterie ‘ sont . donc des donner vous
    entreprises .

  16. Posted June 26, 2014 at 21:10 | Permalink

    Thanks for sharing your thoughts about Development /QV Developer.
    Regards

  17. Posted June 27, 2014 at 19:56 | Permalink

    Heya i’m for the first time here. I found this board and I in finding It really helpful &
    it helped me out a lot. I’m hoping to give something back
    and help others such as you helped me.

    Here is my web site – Qu’est-ce qu’on a fait au Bon Dieu Télécharger

  18. Posted June 28, 2014 at 09:56 | Permalink

    People expect the entertainment to be good, so whether
    you are looking for musicians for hire or magicians to surprise your attendees you will need to ensure they are professionals
    who are good in their chosen field. This allows you to get a very professional sounding quality
    to your music without spending a lot of money on fancy recording studio times.
    When I first moved to Los Angeles in the late 90′s,
    an actor wouldn’t get very far without a huge stack of black
    and white 8×10′s in their repertoire.

  19. Posted June 29, 2014 at 04:08 | Permalink

    Old JDM Automobiles For Sale

    Feel free to visit my website we buy cars

  20. Posted June 30, 2014 at 16:56 | Permalink

    As an enthusiast of information technology encourage any woman interested in IT at my blog.
    By getting of experience professional describe I explore and
    beat multipurpose type furniture – using by with mobile
    phones, on special HP servers, IMB or Cisco.
    Good relations with distributors accesses will me to many gear lot before the premiere.

  21. Posted July 2, 2014 at 15:42 | Permalink

    minecraft gamestop

  22. Posted July 4, 2014 at 10:23 | Permalink

    Fine way of describing, and fastidious post to obtain facts on the topic of my
    presentation subject, which i am going to present in school.

  23. Posted July 8, 2014 at 16:15 | Permalink

    In the article I’ll give advice the choice whether to follow them or not is yours only.
    The best part about this system is that the people who decide to sign up for the list
    are already heavily disposed towards visiting your site or purchasing items from your business.

    It’s easy to import existing data from another application.

  24. Posted July 9, 2014 at 20:48 | Permalink

    What’s up Dear, are you genuinely visiting this website regularly, if so then you will definitely
    obtain fastidious know-how.

    my blog post; Blackline Elite Review

  25. Posted July 10, 2014 at 12:10 | Permalink

    That is a good tip especially to those new to the blogosphere.
    Simple but very accurate information… Many thanks for
    sharing this one. A must read post!

    my blog … Maxx test 300

  26. Posted July 10, 2014 at 19:53 | Permalink

    Can I simply say what a relief to uncover somebody that truly knows what they are talking about on the internet.
    You actually know how to bring an issue to light and make it important.

    More people must read this and understand this side of your story.
    It’s surprising you are not more popular because you definitely possess the gift.

  27. Posted July 14, 2014 at 17:20 | Permalink

    My programmer is trying to convince me to move to .net from PHP.
    I have always disliked the idea because of the costs.

    But he’s tryiong none the less. I’ve been using WordPress on several websites for
    about a year and am worried about switching to another platform.
    I have heard very good things about blogengine.net. Is there a way I can import
    all my wordpress content into it? Any kind of help would be really appreciated!

    Visit my web site tapped out (Beatrice)

  28. Posted July 15, 2014 at 11:18 | Permalink

    Wow, superb blog layout! How long have you been blogging for?
    you make blogging look easy. The overall look of your website is
    fantastic, let alone the content!

  29. Posted July 19, 2014 at 21:30 | Permalink

    Hi, its good piece of writing on the topic of media print, we all know media is a wonderful source of facts.

  30. Posted July 23, 2014 at 08:25 | Permalink

    I’m gone to say to my little brother, that he should also go to see this website on regular basis to get updated from hottest information.

Post a Comment

(required)
(required)

Your email is never published nor shared.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Subscribe without commenting