I have data on a on an excel spreadsheet, the data is in a hierarchy form as on the attached spreadsheet.
How can i load this data to Qlikview and ensure that each product associates with its respective Product Category, Manufacturer and the market. Please also note a product can belong to more than one product category.
