Discussion Board for collaboration on QlikView Scripting.
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,
WHERE ConditionSTORE 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;
Go to Solution.
missing ";" after where
Your file name & path contain spaces so you need to enclose the name in square brackets.
STORE SNF_ALOS into (txt);
And the missing semi-colon as identified by Kush.
Both are correct, thank you so much!