on the left side in the image you can see my Excel file. The database table is the same except that I don't have the "Category 1", "Category 2" column headers. I want to group these using Qlikview - see the small table on the right. So that I can select Category 1 and I only get Col1 to Col3 values.
Can I group the different colums in the load stmt? Do I need to transform the colums to field values.
You can use the crosstable function to load the data and create another table for the categories. You may have to change the headers in the excel file so that all the headers are on the same row, i.e. moving Plant, Year and Month a row down instead of using merged cells.