Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Your Excel sheet name contains an apostrophe, I suspect this is a problem. Try to rename it to something like Detail_YTD_14.
Your Excel sheet name contains an apostrophe, I suspect this is a problem. Try to rename it to something like Detail_YTD_14.
Thanks Michael,
you are right
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)');
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]);
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..
Thanks to all.
I got it
Then do your job by using below link
Qlik Community Tip: Marking Replies as Correct or Helpful
Thankyou very much Anil.
Your guidance is so appreciative.
I am new to Qlik Community. I have many questions.
Hope to see you again