Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

anonymous1
New Contributor III

Creating QVD from SQL

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?

Labels (3)
1 Solution

Accepted Solutions
atoz1158
Contributor II

Re: Creating QVD from SQL

Hi

 

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

View solution in original post

1 Reply
atoz1158
Contributor II

Re: Creating QVD from SQL

Hi

 

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

View solution in original post