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?
