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)"
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.
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.
