Creating QVD from SQL

anonymous1 — Sat, 16 Nov 2024 02:53:09 GMT

hey,

im trying to create a QVD using SQL but keep getting an error : ORA-00923: FROM keyword not found where expected. my code is as follows

TABLE:
SQL
SELECT
"qr.ROWID" as [row_id],
"qr.organization_id",
"qr.collection_id",
"qr.occurrence",
"qr.qa_last_update_date" as [last_update_date],
"qr.qa_last_updated_by" as [last_updated_by_id],
"qr.qa_creation_date" as [creation_date]
FROM
"apps.qa_results" qr,
"apps.qa_plans" qp
WHERE
qp.plan_id = qr.plan_id
;

store TABLE into D:\TABLE.qvd

have i got the syntax wrong somewhere?

Re: Creating QVD from SQL

atoz1158 — Mon, 29 Jul 2019 13:04:15 GMT

Can I suggest you try the following

TABLE:
SQL
SELECT
"qr.ROWID" as [row_id],
"qr.organization_id",
"qr.collection_id",
"qr.occurrence",
"qr.qa_last_update_date" as [last_update_date],
"qr.qa_last_updated_by" as [last_updated_by_id],
"qr.qa_creation_date" as [creation_date]
FROM
"apps.qa_results" qr INNER JOIN
"apps.qa_plans" qp ON qp.plan_id = qr.plan_id
;

store TABLE into D:\TABLE.qvd;

Regards

Adrian

topic Re: Creating QVD from SQL in QlikView

Creating QVD from SQL

Re: Creating QVD from SQL