LOAD & QUALIFY

[#1]

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?

[llauses243 · Accepted solution]

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

[#3]

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...

[#4]

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

[#5]

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.