topic Re: Convert Row to column in QlikView

Convert Row to column

soha1902 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have excel file in below format

Now I want to convert above format as below

Please help me how I achieve this. Thanks in advance.

Anil_Babu_Samineni — Wed, 21 Oct 2020 16:55:22 GMT

This will work

LOAD *
FROM
[https://community.qlik.com/t5/New-to-QlikView/Convert-Row-to-column/m-p/1754612#M394000]
(html, codepage is 1252, embedded labels, table is @1, filters(
Rotate(left),
Rotate(right),
Transpose()
));

soha1902 — Wed, 21 Oct 2020 17:08:14 GMT

I tried but its not working. I have these information in excel.

Anil_Babu_Samineni — Wed, 21 Oct 2020 17:16:47 GMT

Off course with Excel, It should work and While loading you can transpose option and see where it is not working?

Vegar — Thu, 22 Oct 2020 04:46:47 GMT

There is an wizard for this transformative when using the import wizard in QlikView. When using excel the final load will look similar to this.

LOAD *

FROM

[ExcelFile.xlsx](ooxml, embedded labels, table is Sheet1, filters(Transpose()));