topic Re: Store SQL query as qvd in QlikView

Store SQL query as qvd

Iwin — Wed, 30 Jun 2021 07:44:43 GMT

Hi All,

I want to store following query as qvd .

What should I put in load statement as I am getting column not found error currently.

Re: Store SQL query as qvd

Or — Wed, 30 Jun 2021 08:04:34 GMT

Load * would work fine, for obvious reasons.

If you need to manually spell out the columns, check what is returned by the query without a load statement and use that exact naming convention. In Oracle SQL queries, this will often be all UPPERCASE field names (and without the table qualifier).

Re: Store SQL query as qvd

dineshm030 — Wed, 30 Jun 2021 08:56:23 GMT

The column is not available in the mtt table.

Re: Store SQL query as qvd

NitinK7 — Wed, 30 Jun 2021 15:52:37 GMT

tablename:

load *;

SELECT

your sql field

store tablename into [your folder path /tablename.qvd](qvd);