topic Re: Garbage after Statement Error Message...not sure why in QlikView

Garbage after Statement Error Message...not sure why

Wed, 25 Nov 2020 16:16:04 GMT

When I try and reload this I get the following error message. Can anyone help?

Garbage after statement

Joe's_SCload:

LOAD [Partner Name],

[Partner ID],

[Profit Center],

[Profit Center Name],

[Business Unit],

[Job Level],

[Svc Group],

[Svc Line],

Network,

[Industry Group],

Industry,

Goal as [Pipeline Goal],

[Current Month End],

[Avg 12 Month Rolling],

[Past Due],

Onshore as [ADV Onshore Hours],

Offshore as [ADV Offshore Hours],

[Offshore %],

[Mgmt %],

[Staff %],

Onshore1 as [AUD Onshore Hours],

Offshore1 as [AUD Offshore Hours],

[Hours Outside Function],

[Hours Outside Group],

[Hours Outside Line],

[Hours Outside of Network],

[Hours Outside of PC],

[Chargeable Hrs on Eng of Other Ptr/MDs],

[Family Rev less Managed Rev],

[Total Sales Credit],

[Teaming Credit],

[% Teaming Credit],

[Sales Credit outside own opportunity],

[% Sales Credit outside own opporutnity],

[Referral Credit - Opps where not Opp Ptr],

[# of Opportunities],

[# of Sales Credit Teaming Opportunities],

[% Opportunities with Sales Credit Teaming],

[# of Partners on Sales Credit Teaming Opportunities],

[Avg # of Partners on Sales Credit Teaming Opportunties],

[Total Rev Goal],

[ADV Total Revenue],

[AUD Total Revenue],

[Total Revenue (Excl no Goals)],

[Total Revenue]as [Total Revenue (ADV + AUD)],

[ADV Fee Revenue],

[ADV Fee RPH],

[ADV Profit $],

[ADV Profit %],

[Family Revenue Total],

[Lead MPP Partner (Y/N)],

[LP Total Revenue] as [LP Total Revenue (MPP)],

[Total Revenue AUD] as [Total Revenue AUD (MPP)],

[Total Revenue TAX] as [Total Revenue TAX (MPP)],

[Total Revenue ADV] as [Total Revenue ADV (MPP)],

[LP Total Revenue FY Plan],

[LP Total Revenue FY Plan AUD],

[LP Total Revenue FY Plan TAX_x000D_],

[LP Total Revenue FY Plan ADV_x000D_],

Onshore2 as [Audit Support Onshore Hours],

Offshore2 as [Audit Support Offshore Hours],

[Offshore %1],

[Total Revenue1] as [Total Revenue (AUD Support)],

[Profit $],

Interest,

Investment,

Unbilled,

[Total AR],

DSO,

[AR 90+ Days],

[AR 180+ Days],

Goal1,

YTD,

[Non-Charge],

Chargeable,

[Total Expenses],

[Expense Rank Non-Charge],

[Expense Rank],

F79,

[ADV Mgmt Hours],

[ADV Staff Hours],

[ADV Labor Cost],

[AR Open],

[ADV 12month Rolling]as [Total ADV&AUD 12Month Rolling],

[Chargeable Hours],

[Base Hours],

[PYTD Revenue for Growth],

[Total Hours],

[Hours Outside Function1],

[Hours Outside Group1],

[Hours Outside Line1],

[Hours Outside of Network1],

[Hours Outside of PC1],

[Total Pipeline],

[Goal Chargeable Hours],

Practice

FROM

[Copy of 4 _Partner_Scorecard_ADV_FINAL_COMMERCIAL_ONLY_FYTD16Feb_with base data for pivots.xlsx]

(ooxml, embedded labels, header is 5 lines, table is [Partner YTD qlikview]);

Re: Garbage after Statement Error Message...not sure why

Chanty4u — Tue, 29 Mar 2016 16:50:45 GMT

try to debug the code once...u will get to know where exctly it wrng

i think the code seems correct.

or else try to copy code to other qvw and reload that one.

Re: Garbage after Statement Error Message...not sure why

Chanty4u — Tue, 29 Mar 2016 16:52:55 GMT

moreover

what is this?

(ooxml, embedded labels, header is 5 lines, table is [Partner YTD qlikview]);

is this ur table name? if yes u can replace with [Joe's_SCload]

and reload once

Re: Garbage after Statement Error Message...not sure why

Tue, 29 Mar 2016 16:54:35 GMT

Thanks I'll give it a try

Re: Garbage after Statement Error Message...not sure why

kkkumar82 — Tue, 29 Mar 2016 16:55:52 GMT

Not sure like Chanty but my suggestion is try to reduce some of the columns in the load script if possible even try with one column so that u can find if you really missed something in the script delimiters.

Re: Garbage after Statement Error Message...not sure why

sunny_talwar — Tue, 29 Mar 2016 17:00:09 GMT

That must be the name of the sheet from the Excel file Suresh. I wouldn't recommend changing that.

Re: Garbage after Statement Error Message...not sure why

satishkurra — Tue, 29 Mar 2016 17:00:45 GMT

I figured out the issue

[ADV 12month Rolling]as [Total ADV&AUD 12Month Rolling],

Please put space before as

Like this

[ADV 12month Rolling] as [Total ADV&AUD 12Month Rolling],

Re: Garbage after Statement Error Message...not sure why

sunny_talwar — Tue, 29 Mar 2016 17:02:13 GMT

Not sure how it is with Excel, but inline had no trouble without space:

Table:

LOAD [Dim]as Dim1;

LOAD * Inline [

Dim

];

Re: Garbage after Statement Error Message...not sure why

Chanty4u — Tue, 29 Mar 2016 17:07:53 GMT

yes sunny.

fr inline or Excel load it doesnt changed the reload will works.

"as" doesn't matter for this.

may be in script he has anything misplaced down thee script or below the variables something is there.

Re: Garbage after Statement Error Message...not sure why

sunny_talwar — Tue, 29 Mar 2016 17:07:55 GMT

Can you try changing the table name from -> Joe's_SCload to [Joe's_SCload]

Re: Garbage after Statement Error Message...not sure why

Chanty4u — Tue, 29 Mar 2016 17:12:44 GMT

yes sunny its excttly correct

its woring fine after renaming

if we give as normal is givng error i think " ' " single quote is not reading for table name

Joe's_SCload to [Joe's_SCload]

Re: Garbage after Statement Error Message...not sure why

satishkurra — Tue, 29 Mar 2016 17:17:54 GMT

All

Issue 1 : No space before as

Issue 2: Joe's_SCload, The single quotes in the table name.

Attaching the excel file and script for reference, please check...

Re: Garbage after Statement Error Message...not sure why

Tue, 29 Mar 2016 17:33:00 GMT

Thanks for catching that. I did correct that but it still gave me the same error message

Re: Garbage after Statement Error Message...not sure why

Tue, 29 Mar 2016 17:35:04 GMT

Hi Sunny,

I went back and removed the naming and it loaded.

THanks,

Re: Garbage after Statement Error Message...not sure why

sunny_talwar — Tue, 29 Mar 2016 22:39:17 GMT

So everything good and running? If you have your issues resolved, I would request you to close this thread by marking the correct and helpful answers.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

Re: Garbage after Statement Error Message...not sure why

Chanty4u — Wed, 30 Mar 2016 14:18:56 GMT

coooooooool