Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I am very new to QlikSense. I am trying to run a script which pulls the data from SharePoint.The field does exist in the exel file. And I have also checked for the name of the field to be case sensitive or not.
I am getting the below error:
Date << Last Update Date
Lines fetched: 1
The following error occurred:
Field not found - <Team>
The error occurred here:
Checkbook:
LOAD
Team,
Department,
"Year",
"Group",
Quarter,
"Budget Line",
"Budget Plan $",
"Budget Sub-Category",
"Budget Category",
"Funnel Stage",
"Name/ Description",
"Parent Campaign",
"Campaign/ Initiative",
"Tactic/Activity",
"Finance Tactic Group" as "Tactic Group",
"Forecast Amount",
Committed,
JMF,
Vendor,
If(Match([Tactic/Activity],'Advertising - Digital','Collateral - e-book','Content Syndication','E-mail','Event - Online','Online Syndication','Paid Search','SEO','Social Media Promotion','Webinar')=0,'Other','Digital') AS DigitalMarketingFlag
FROM [lib://SharePoint - Marketing Finance/Shared Documents\2017 Checkbook Registers\Global\GLOBAL checkbook.xlsx]
(ooxml, embedded labels, table is [Roll Up]) where not [Team]=0
Hi Ihor,
I tried it without the names of the field it gives me the below error:
Date << Last Update Date Lines fetched: 1
The following error occurred:
Error: File Extdata.cpp, Line 2391
The error occurred here:
Checkbook: LOAD * FROM [lib://SharePoint - Marketing Finance/Shared Documents/2017 Checkbook Registers/Global/GLOBAL checkbook.xlsx] (ooxml, embedded labels, table is [Roll Up]).
To give you a background: The "Global Checkbook" xlsx file was under a shared folder initially. But now since the SharePoint connection works I tried to pull the Global Checkbook file from SharePoint and hence I happen to come across this error.
Hi Ferry,
I tried it without the names and without the where clause it gives me the below error:
Date << Last Update Date Lines fetched: 1
The following error occurred:
Error: File Extdata.cpp, Line 2391
The error occurred here:
Checkbook: LOAD * FROM [lib://SharePoint - Marketing Finance/Shared Documents/2017 Checkbook Registers/Global/GLOBAL checkbook.xlsx] (ooxml, embedded labels, table is [Roll Up]).
To give you a background: The "Global Checkbook" xlsx file was under a shared folder(Marketing Files) initially. But now since the SharePoint connection works I tried to pull the the same Global Checkbook file from SharePoint and hence I happen to come across this error.
Fyi:
Dashboard failed to refresh since the connection is to SharePoint rather than to the shared folder.
I don't get it its the same file. But the only difference is now the connection is to SharePoint and not to the shared folder.
Please help!.
Hi Ajinkya.
Try these troubleshooting suggestions:
or
or
Hope this helps,
I have only limited experience with the Sharepoint environment.
The error points in the direction of either security on the sharepoint file/path or a path that it can't find in the sharepoint Lib definition.
It could be that you already pointed the Lib to a certain folder, in this case 'Marketing Files' and in the file path you again mention the folder. Which will result in something like this:
Sharepoint:/Marketing Files/Marketing Files/GLOBAL checkbook copy.xlsx
Could this be the case?
Regards,
Ferry
Hi Ferry and Everyone,
It was a very silly mistake on my end. The Table [Roll Up] had a "-" between the Roll and Up.
The actual table was [Roll-Up] and it was causing to not finding the field <Team>.
Thank you everyone to troubleshoot the issue. Appreciate your help very much.
Sometimes this happens.
Glad you've found it in the end