topic LOAD & QUALIFY in QlikView

LOAD & QUALIFY

Thu, 02 Dec 2010 09:29:12 GMT

Im using SQL SELECT to get 2 tables from a SQL database. I use QUALIFY to outomatically add TABLE1 and TABLE2 on the field names.

Now i want to load the 2 tables (70odd fields each) using LOAD * but still be able to specify the one field i want to use to link between the two tables.

my "idea" is this


LOAD *
TABLE1.DocNum as DocNum;
FROM TABLE1.QVD (QVD);
LOAD *
TABLE2.DocNum as DocNum;
FROM TABLE2.QVD (QVD);

this possible or how do i go about this LOAD a table with +-70fields and not having to type and rename each field using LOAD AS?

LOAD & QUALIFY

llauses243 — Thu, 02 Dec 2010 09:49:02 GMT

Hi,

This is my offer ...

TableNew:

LOAD *, TABLE1.DocNum as DocNum FROM TABLE1.QVD (QVD);

LOAD *, TABLE2.DocNum as DocNum FROM TABLE2.QVD (QVD);

Very important position of the comma & point/comma

Good luck, Luis

LOAD & QUALIFY

Thu, 02 Dec 2010 09:55:26 GMT

first use qualify + field then unqualify the other fields so that you don't have to use alias on the other fields..

hope this helps...

LOAD & QUALIFY

Thu, 02 Dec 2010 11:24:36 GMT

excellent...dont know how i missed that, i thought i tried it all including that missing comma

LOAD & QUALIFY

Thu, 02 Dec 2010 11:25:39 GMT

yes thanx, thats how im doing it currently, my only issue is i have around 10tables with the same fields so i have to qualify them first, then load the lot and rename the key's only.