8 Replies Latest reply: Mar 11, 2013 3:14 AM by lin ye RSS

    load qvd and resident table

    lin ye

      Hi, still pretty new to qlikview and need someone who can tell me the best way to the joins

       

      main:

      load key,

      field

      from 123.qvd (qvd);

       

      left join (main)

      load key,

      value

      from 456.qvd (qvd);

       

       

      final_tbl:

      noconcatinate load

      key,

      field,

      value

      resident main

      where not match(value, '1', '2');

       

       

      I will get no values at all in final tbl. Why?

       

      But if i do this:

       

      load main-->left join the value --> store main into a qvd and drop it --> pull that qvd again in final_tbl and do the where statement

       

      I will get the results i what. how is these 2 methods different?