topic Re: Garbage after statement error in QlikView

Garbage after statement error

Wed, 25 Nov 2020 16:16:04 GMT

I am trying to load this table, but I am getting Garbage after statement error, why it is coming, how to avoid it? Can some one please help me...

Re: Garbage after statement error

Anonymous — Mon, 27 Feb 2017 23:56:17 GMT

Your Excel sheet name contains an apostrophe, I suspect this is a problem. Try to rename it to something like Detail_YTD_14.

Re: Garbage after statement error

Tue, 28 Feb 2017 01:26:18 GMT

Thanks Michael,

you are right

Re: Garbage after statement error

Anil_Babu_Samineni — Tue, 28 Feb 2017 03:34:21 GMT

Do you got Answer, If so close this thread by flag correct answer.

Still you don't want to change the Sheet name then you can use something like below. It should work even if you have 'Single Quote on your sheet name'

SET Var = "Detail_YTD'14";

LOAD A,

FROM

(ooxml, embedded labels, table is '$(Var)');

Re: Garbage after statement error

shraddha_23 — Tue, 28 Feb 2017 04:46:01 GMT

Hello,

you don't want to change the Sheet name then you can use something like as below

put square bracket i.e [Detail_YTD'14]

for e.g:

Load

[Total BMM],

[Onsite Revenue],

[Pr Adj],

Reim,

[Pass Thru],

[Total Revenue],

[Old vertical],

F24

FROM

(ooxml, embedded labels, table is [Detail_YTD'14]);

Re: Garbage after statement error

priyasawant — Tue, 28 Feb 2017 09:27:58 GMT

After loading the excel the sheet name consist of square brackets.. if they don't have then you write the sheet name in square brackets.

Please find the below image..

Re: Garbage after statement error

Tue, 28 Feb 2017 16:15:11 GMT

Thanks to all.

I got it

Re: Garbage after statement error

Anil_Babu_Samineni — Tue, 28 Feb 2017 16:16:42 GMT

Then do your job by using below link

Qlik Community Tip: Marking Replies as Correct or Helpful

Re: Garbage after statement error

Tue, 28 Feb 2017 16:22:39 GMT

Thankyou very much Anil.

Your guidance is so appreciative.

I am new to Qlik Community. I have many questions.

Hope to see you again