Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am facing script error while trying to connect a data table from MS Access to Qlikview. Here is the error message,
SQL##f - SqlState: 07001, ErrorCode: 4294964286, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.
Concatenate
SQL SELECT "Browser Meta Info-Browser" as Browser_Meta_Info_Browser,
"Browser Meta Info-Version" as Browser_Meta_Info_Version ,
"Business Unit" as Business_Unit,
CES as Customer_Effort_Score_Flag,
"CES Count" as Total_Customer_Effort_Score_Flag,
"Count" as Satisfied_Response_Flag,
CountryCode as Country_Code,
Csat as Completely_Satisfied_Flag,
Detractors as Detractor_Flag,
DocumentID as Document_Id,
Dsat as Dissatisfied_Flag,
GeoLocation as Geo_Location,
"Is your product under warranty?" as Warranty_Type,
LanguageCode as Language_Code,
"NPS Count" as Recommend_Response_Flag,
OS as Browser_Meta_Info_Operating_System,
PL as Product_Line,
"Product Age" as Product_Age,
Promoters as Promoter_Flag,
"Site_Referrer",
StartDate as Start_Date,
"Survey_Name",
TCR as Completion_Response_Flag,
"TCR Count" as Total_Completion_Response_Flag,
Template as Template_Name
FROM "Qualtrics Survey Data.accdb".PushSurveyData
WHERE (Start_Date >'8/31/2017'
AND Start_Date <'10/5/2017')
Please help me with this.
Iirc you need to add # characters around dates if you use ms-access
WHERE (Start_Date > #8/31/2017# AND Start_Date < #10/5/2017# )