topic Re: Error in Syntax in QlikView

Error in Syntax

varunreddy — Fri, 13 Nov 2015 17:04:19 GMT

Hi Guys,

The syntax I was trying:

set vSourceData = \\hbeu.adroot.hsbc\dfsroot\GB002\GDMP\01.GDMP\04. Data Quality\25. Data Quality Metrics & Reporting\98. Reporting\DQ_Qlikview\Production\Data Files;

set vQVDPath = \\hbeu.adroot.hsbc\dfsroot\GB002\GDMP\01.GDMP\04. Data Quality\25. Data Quality Metrics & Reporting\98. Reporting\DQ_Qlikview\Production\QVD;

Load

* from

$(Include=z:\gdmp\01.gdmp\04. data quality\25. data quality metrics & reporting\98. reporting\dq_qlikview\include files\include file.txt)\

DQIM_AllIssues_History - Master_Post.xlsx]

Can anyone rectify the errror?

Regards,

Varun

Re: Error in Syntax

Gysbert_Wassenaar — Fri, 13 Nov 2015 17:12:23 GMT

You seem to have an include statement inside your load statement. Remove that line to begin with. The load statement is also missing a starting [ in front of the name of the source file and it doesn't seem to have a format specification for the excel file. Try creating a load statement using the file wizard instead.

Re: Error in Syntax

varunreddy — Fri, 13 Nov 2015 17:15:32 GMT

Can you be specific?

Which line I need to remove?

Re: Error in Syntax

Gysbert_Wassenaar — Fri, 13 Nov 2015 17:20:39 GMT

There's only one include statement. If you can't tell where it is then I think you shouldn't be using it:

$(Include=z:\gdmp\01.gdmp\04. data quality\25. data quality metrics & reporting\98. reporting\dq_qlikview\include files\include file.txt)\

By preference don't put anything in your script if you don't know what it does.

Re: Error in Syntax

varunreddy — Fri, 13 Nov 2015 17:23:17 GMT

I need to pull data from prod environment. So, I am trying to create an include file and trying to extract data.

Is there a way to extract?

Regards,

Varun

Re: Error in Syntax

Gysbert_Wassenaar — Fri, 13 Nov 2015 17:39:47 GMT

Use the File Wizard to create your load statements.