topic Preceding Load on Preceding Load in QlikView

Preceding Load on Preceding Load

avastani — Thu, 18 Jun 2009 20:48:04 GMT

Does doing a preceding load on a preceding load concatenate the table to itself?

for eg.

Table:

LOAD *, someField AS someThing;

LOAD *, someField2 AS someThing2;

LOAD .... FROM someqvd.qvd;

Preceding Load on Preceding Load

rwunderlich — Thu, 18 Jun 2009 23:02:43 GMT

No -- it does not create any additional rows. In your example, your final table will have one row for each row in someqvd.qvd. Each row will also contain the added fields SomeThing and someThing2.

-Rob

Preceding Load on Preceding Load

johnw — Fri, 19 Jun 2009 03:44:28 GMT

But if you WANT to concatenate, that's easy too. Just use CONCATENATE LOAD.