Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]);
Can you try changing the table name from -> Joe's_SCload to [Joe's_SCload]
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.
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
Thanks I'll give it a try
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.
That must be the name of the sheet from the Excel file Suresh. I wouldn't recommend changing that.
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],
Not sure how it is with Excel, but inline had no trouble without space:
Table:
LOAD [Dim]as Dim1;
LOAD * Inline [
Dim
1
];
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.
Can you try changing the table name from -> Joe's_SCload to [Joe's_SCload]