topic Re: join and Concatenate in QlikView

join and Concatenate

Thu, 12 Jul 2012 09:19:51 GMT

I have four tables a,b,c,d

how can I get the result

(a join b)

Concatenate

(c join d),

load * from a.qvd;

join (a)

load * from b.qvd;

Concatenate (a)

load * from c.qvd;

join

load * from d.qvd;

seems wrong

Best Regards !

Re: join and Concatenate

nagaiank — Thu, 12 Jul 2012 09:26:25 GMT

Maybe the following will work:

ab:

load * from a.qvd (qvd)

join (ab) load * from b.qvd (qvd);

cd:

noconcatenate load * from c.qvd (qvd);

join (cd) load * from d.qvd (qvd);

join (ab) load * resident cd;

drop table cd;

Re: join and Concatenate

Thu, 12 Jul 2012 10:21:08 GMT

Thanks for your answer.

Re: join and Concatenate

jonathandienst — Thu, 12 Jul 2012 11:13:32 GMT

You may want to concatenate for the last step. This is very different to a join in the last step if the field names are the same in (a join b) and (c join d). The code is mostly the same:

ab:

load * from a.qvd (qvd)

join (ab) load * from b.qvd (qvd);

cd:

noconcatenate load * from c.qvd (qvd);

join (cd) load * from d.qvd (qvd);

concatenate(ab)

load * resident cd;

drop table cd;

Hope that helps

Jonathan