Garbage after statement error

[#1]

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...

[Anonymous · Accepted solution]

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

[#3]

Thanks Michael,

you are right

[Anil_Babu_Samineni]

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,

    B

FROM

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

[shraddha_23]

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]);

[priyasawant]

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..

[#7]

Thanks to all.

I got it

[Anil_Babu_Samineni]

Then do your job by using below link

Qlik Community Tip: Marking Replies as Correct or Helpful

[#9]

Thankyou very much Anil.

Your guidance is so appreciative.

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

Hope to see you again