Re: Loading A Two Dimension Excel File (with a dimension on the top)
This can be achieved by Cross Table concept, Please see below to understand the concept.
A cross table is a common type of table featuring a matrix of values between two orthogonal lists of header data. It could look like the table below:
If this table is simply loaded into QlikView, the result will be one field for Year and one field for each of the months. This is generally not what you would like to have. One would probably prefer to have three fields generated, one for each header category (Year and Month) and one for the data values inside the matrix.
This can be achieved by adding the crosstable prefix to your load or select statement.The statement for loading this cross table could be: