Preceding Load on Preceding Load

[avastani]

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;

[rwunderlich]

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

[johnw]

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