Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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
But if you WANT to concatenate, that's easy too. Just use CONCATENATE LOAD.