CODEWITHSUNDEEP
excelloadinginlinemultiple-columnsqlikview
SPP
SPP

Reputation: 21

Loading multiple rows of column to store as qvd

I'm trying to load this table and store it as qvd. But the problem is I don't want to default header to appear in cell which only show header name in second row not first row. I also like to store A,B,C,D as Alphabet Group and avg score as another value. I have tried using crosstable and load inline but failed.

Your help is much appreciated.

Upvotes: 0

Views: 148

Answers (1)

KoenBal
KoenBal

Reputation: 141

Crosstable is the way to go. You should calculate the average in the frontend.

If you can't get the crosstable working. Build the table manually.

It should have 3 columns (Subject, Alphabet group, score) and look like:

Table

Upvotes: 1

Related Questions