topic Re: Can i use the first column values as column headers? in QlikView

Can i use the first column values as column headers?

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

My raw excel data format is as per below

What i want is the first column values to become the column headers, and the remaining column data to become the row data

I would like to know how i can do this without tampering with the raw excel data format. Thank you.

tamilarasu — Wed, 23 Mar 2016 09:36:27 GMT

Hi Leow,

You can use Transformation wizard to achieve the above result.

LOAD [Eval No.],

[Evaluator Name:],

[Staff Name:],

Score

FROM

Book11.xlsx

(ooxml, embedded labels, table is Sheet1, filters(

Transpose()

));

MarcoWedel — Wed, 23 Mar 2016 09:45:57 GMT

Hi,

the Import wizard can help you with this kind of transformations.

Just use the transpose option you can find there.

Regards

Marco

Anonymous — Wed, 23 Mar 2016 09:50:52 GMT

while load the data from excel file use transformation step...

Gysbert_Wassenaar — Wed, 23 Mar 2016 09:53:30 GMT

You can also try a CrossTable load:

CrossTable(EvaluationNumber, Value)

LOAD * FROM MyExcelFile.xlsx (ooxml, embedded labels, table is Sheet1);