Field not Found

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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!.

[ArnadoSandoval]

Hi Ajinkya.

Try these troubleshooting suggestions:

• Exclude the Team column from the LOAD and WHERE filter: if it works some special characters are part of its name.

or

• Rename Team to something else in your Excel file and script (NOTE: Make a copy of the Excel file and try this test with the copy).

or

• You are mixing Team (in the LOAD) with [Team] in the WHERE, try enclosing Team in double quotes in the LOAD, like this "Team".

Hope this helps,

[flaurntiu]

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

[Anonymous]

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.

[flaurntiu]

Sometimes this happens.
Glad you've found it in the end