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]);
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]
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...
Thanks for catching that. I did correct that but it still gave me the same error message
Hi Sunny,
I went back and removed the naming and it loaded.
THanks,
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
coooooooool