Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am really struggling to find an answer to this question. I have created a concatenated table by pulling data from two different ODBC connections. Now I want to select distinct from this newly created table. I cannot get this to work and can't believe how hard it has been to do something so simple. Please somone out there let me know, what am I doing wrong?
Have you tried a Distinct Load?
DistinctTable:
NOCONCATENATE LOAD DISTINCT * RESIDENT YourCreatedTable;
drop YourCreatedTable;
Or using WHERE NOT EXISTS(..) in your original LOADs?
edit: It might be helpful if you could post your current code.
Have you tried a Distinct Load?
DistinctTable:
NOCONCATENATE LOAD DISTINCT * RESIDENT YourCreatedTable;
drop YourCreatedTable;
Or using WHERE NOT EXISTS(..) in your original LOADs?
edit: It might be helpful if you could post your current code.
Thank you so much for the quick reply swuehl. I did not realize that you have to type NOCONCATENATE before moving on to the next subquery.
Thank you so much for the quick reply swuehl. I did not realize that you have to type NOCONCATENATE before moving on to the next subquery.
QV will auto-concatenate tables when these tables have the exact same fields.
So whenever you use something like
LOAD * RESIDENT Table;
this will just concatenate to the resident table. No new table is created.
NOCONCATENATE Load prefix will prevent QV from auto-concatenation.
Thank you so much for your help swuehl