topic Re: Renaming SQL tables in QV in QlikView

Renaming SQL tables in QV

Fri, 30 Mar 2012 18:01:14 GMT

I am new to QlikView, so I apologize if this is an easy syntax question. I am loading data using a SQL Select statement that joins two tables and I want to then reference the query results set as a table in QlikView. It appears that QV names the result using the first table in the query, appended with a right parenthesis , e.g., ABT_BASELINE_MILESTONES) . Is there a way to rename the resulting dataset with a new table name in QV?

Re: Renaming SQL tables in QV

Fri, 30 Mar 2012 18:22:24 GMT

This is an example with qvd files but it is the same with SQL query. Or you have the choise to store the tables to qvd files and then do the join. In the following example you refer to the joined tables as 'Items' which is used to store the file to a new qvd.

LOAD item_id,
item_descr,
cat001_id

FROM
C:\Dim_Items.qvd
(qvd);

left join
LOAD cat001_id,
descr

FROM
C:\ProdGroup.qvd
(qvd);

Store Items into C:\Items.qvd (qvd);

Items:

Re: Renaming SQL tables in QV

johnw — Fri, 30 Mar 2012 23:08:24 GMT

[My New Table Name]:
LOAD *
;
SQL
SELECT Something, SomethingElse
FROM SomeTable
WHERE SomeValue > 50
;

I believe the LOAD *; isn't technically necessary, but I always include it.

Renaming SQL tables in QV

Tue, 03 Apr 2012 13:51:36 GMT

Thanks, John, this is exactly what I needed. -Scott