topic Re: Storing a script into a CSV file-STORE error in QlikView

Storing a script into a CSV file-STORE error

Mon, 14 Sep 2015 16:12:25 GMT

I currently run a script in QV (snippet here) an it runs properly. Once I try to add a STORE step, I get an error. Can someone help me figure out what the correct syntax is supposed to be?

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Incorrect syntax near 'STORE'.

Here is the script:

SNF_ALOS:
SELECT DISTINCT

                      Select1,
                      Select2,
                      Select3,

FROM Table

WHERE Condition

STORE SNF_ALOS into V:\Senior Products - Finance\SER Analysts\Clinical Analyst\Monthly Leadership Reports\SNF_ALOS\monthly_SNF_ALOS.csv(txt);
DROP Table SNF_ALOS;

Thank you!

Re: Storing a script into a CSV file-STORE error

Kushal_Chawda — Mon, 14 Sep 2015 16:23:11 GMT

missing ";" after where

Re: Storing a script into a CSV file-STORE error

Colin-Albert — Mon, 14 Sep 2015 16:24:19 GMT

Your file name & path contain spaces so you need to enclose the name in square brackets.

STORE SNF_ALOS into (txt);

Re: Storing a script into a CSV file-STORE error

Colin-Albert — Mon, 14 Sep 2015 16:25:30 GMT

And the missing semi-colon as identified by Kush.

Re: Storing a script into a CSV file-STORE error

Mon, 14 Sep 2015 16:38:47 GMT

Both are correct, thank you so much!