Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
join (GlobalData)
load distinct Vendor,
upper(Vendor) as SAccess,
1 as All
Resident GlobalData;
join (GlobalData)
load distinct Vendor,
upper(left(Vendor, 4)) as SAccess ,
4 as All
Resident GlobalData;
join (GlobalData)
load distinct Vendor,
upper(left(Vendor,5)) as SAccess ,
5 as All
Resident GlobalData;
here when I take list box for All, I see only 1 is getting selected and the rest 4 & 5 were greyed out
john
John, forget about my previous post.
The Outer JOIN is essential to your operation as you will use it to concatenate, but it will only work well in a specific circumstance: you can OUTER JOIN to a table that contains (many) other field values but the new records will all have NULL values in the other fields (note that this is based on some guesswork as you're not posting the remainder of your script.)
Manish's example works as a true concatenate because the JOINs do load all field values that were in the original table in the first place. Meaning no NULL values anywhere.
To see what I mean, open Table Viewer (Ctrl-T) and check the contents of table GlobalData.
Also note that every operation like
[LEFT|RIGHT|INNER|OUTER] JOIN (GlobalData)
LOAD DISTINCT ...
RESIDENT GlobalData;
will make GlobalData DISTINCT too, as the DISTINCT keyword propagates to the Target table as well. See the JOIN help topic in QV Desktop Help.
Peter
Thanks Peter, I'll try this as suggested.
john