topic Re: Subquery a table in QlikView

Subquery a table

Anonymous — Fri, 28 Jun 2013 17:05:10 GMT

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?

Re: Subquery a table

swuehl — Fri, 28 Jun 2013 17:11:46 GMT

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.

Re: Subquery a table

Anonymous — Fri, 28 Jun 2013 17:21:20 GMT

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.

Re: Subquery a table

Anonymous — Fri, 28 Jun 2013 17:21:28 GMT

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.

Re: Subquery a table

swuehl — Fri, 28 Jun 2013 17:57:42 GMT

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.

Re: Subquery a table

Anonymous — Fri, 28 Jun 2013 17:59:23 GMT

Thank you so much for your help swuehl