Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Data Load failed.

Hi guys,

I'm beginner on Qlik Sense and I'm doing some courses.

In module "Foundations of Building Visualizations (QS Nov 2019)" (https://qcc.qlik.com/course/view.php?id=1434), I'm trying to load Example Files but i recive the error: Data Load Failed. Resolve the problem and refresh the data.

I follow the tip to use debug and a get the mensenge:

"Cannot open file: 'lib://InitialExampleFiles/InternationalApparelData.xlsx' (Native Path: *** System error: ***): [Customers]: LOAD [CustomerID], [Customer], [ContactName], [Address], [City], [Country], [CountryCode], [Region], [PostalCode], [Latitude], [Longitude], [Fax], [Phone], APPLYMAP( '__cityKey2GeoPoint', APPLYMAP( '__cityName2Key', LOWER([City])), '-') AS [Customers.City_GeoInfo], APPLYMAP( '__countryCodeIsoTwo2Polygon', UPPER([CountryCode]), '-') AS [Customers.CountryCode_GeoInfo], GeoMakePoint([Latitude], [Longitude]) AS [Longitude_Latitude] FROM [lib://InitialExampleFiles/InternationalApparelData.xlsx] (ooxml, embedded labels, table is Customers)
11:42:01 PM
Cannot open file: 'lib://InitialExampleFiles/InternationalApparelData.xlsx' (Native Path: *** System error: ***): [Employees]: LOAD [EmployeeID], [Extension], [EmployeeName], [EmployeeGender], [Hire Date], [Office], [Supervisor], [JobTitle], [AnnualSalary], [SalesTarget] FROM [lib://InitialExampleFiles/InternationalApparelData.xlsx] (ooxml, embedded labels, table is Employees)
11:42:04 PM
Cannot open file: 'lib://InitialExampleFiles/InternationalApparelData.xlsx' (Native Path: *** System error: ***): [Offices]: LOAD [Office], [OfficeLocation], APPLYMAP( '__cityKey2GeoPoint', APPLYMAP( '__cityName2Key', LOWER([OfficeLocation])), '-') AS [Offices.OfficeLocation_GeoInfo] FROM [lib://InitialExampleFiles/InternationalApparelData.xlsx] (ooxml, embedded labels, table is Offices)
11:42:08 PM
Cannot open file: 'lib://InitialExampleFiles/InternationalApparelData.xlsx' (Native Path: *** System error: ***): [OrderHeader]: LOAD [OrderDate], [CustomerID], [EmployeeID], [ShippingCost], [OrderID], [ShippingCompany], [DeliveryDate] FROM [lib://InitialExampleFiles/InternationalApparelData.xlsx] (ooxml, embedded labels, table is OrderHeader)
11:43:08 PM
Cannot open file: 'lib://InitialExampleFiles/InternationalApparelData.xlsx' (Native Path: *** System error: ***): [Category]: LOAD [CategoryID], [CategoryName], [Department], [Description] FROM [lib://InitialExampleFiles/InternationalApparelData.xlsx] (ooxml, embedded labels, table is Category)
11:43:09 PM
Cannot open file: 'lib://InitialExampleFiles/InternationalApparelData.xlsx' (Native Path: *** System error: ***): [Products]: LOAD [ProductID], [CategoryID], [ProductName], [SupplierID] FROM [lib://InitialExampleFiles/InternationalApparelData.xlsx] (ooxml, embedded labels, table is Products)
11:43:11 PM
Cannot open file: 'lib://InitialExampleFiles/InternationalApparelData.xlsx' (Native Path: *** System error: ***): [OrderDetails]: LOAD [OrderID], [ProductID], [Quantity], [Sales], [Discount], [CostOfSales], [GrossProfit] FROM [lib://InitialExampleFiles/InternationalApparelData.xlsx] (ooxml, embedded labels, table is OrderDetails)
11:43:12 PM
Cannot open file: 'lib://InitialExampleFiles/InternationalApparelData.xlsx' (Native Path: *** System error: ***): [Suppliers]: LOAD [SupplierID], [Supplier], [SupplierContact], [SupplierCountry], APPLYMAP( '__countryCodeIsoThree2Polygon', APPLYMAP( '__countryName2IsoThree', LOWER([SupplierCountry])), '-') AS [Suppliers.SupplierCountry_GeoInfo] FROM [lib://InitialExampleFiles/InternationalApparelData.xlsx] (ooxml, embedded labels, table is Suppliers)
11:43:13 PM
Cannot open file: 'lib://InitialExampleFiles/InternationalApparelData.xlsx' (Native Path: *** System error: ***): [Territories]: LOAD [EmployeeID], [TerritoryID] FROM [lib://InitialExampleFiles/InternationalApparelData.xlsx] (ooxml, embedded labels, table is Territories)"
 
Any help?
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi

If you have downloaded the course QVF files then you can only use Analysis and Story

because the data they used to load will not be in your local system so whenever you try to reload the data it will throw an error and even though if you have the data the path should be set properly then only you can load the data.

Hope this info helps

Thanks

View solution in original post

2 Replies
Highlighted
Partner
Partner

Hi

If you have downloaded the course QVF files then you can only use Analysis and Story

because the data they used to load will not be in your local system so whenever you try to reload the data it will throw an error and even though if you have the data the path should be set properly then only you can load the data.

Hope this info helps

Thanks

View solution in original post

Highlighted
Contributor
Contributor

Thank you!