topic Re: How to convert column data to row data in QlikView

How to convert column data to row data

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

Hi,

I want how to convert column data to rowdata in qlikview

Ex: Name Maths English

kris 99 78

Raja 90 66.

above example

I need convert to column to row like tat

Name kris Raja

Maths 99 90

English 78 66.

srinu1331 — Fri, 23 Feb 2018 06:23:28 GMT

Using through CrossTable Concept

qlik4asif — Fri, 23 Feb 2018 06:26:30 GMT

While loading file Select Enable Transformation step button

Go to rotate tab

Use Left and Transpose buttons

You can see preview there

And then load file

qlik4asif — Fri, 23 Feb 2018 06:29:11 GMT

Code will generate like this

Directory;

LOAD Name,

Kris,

Raja

FROM

Book2.xlsx

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

Rotate(left),

Transpose(),

Rotate(left)

));

qlik4asif — Fri, 23 Feb 2018 06:33:33 GMT

Hope i have answered ur question:)

sahadevpatil140 — Fri, 23 Feb 2018 06:47:34 GMT

Hi,

Browse input data

click on Enable Transformation step -> Rotate -> Transpose

Regards

Sahadev