Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

krishna14
New Contributor

How to convert column data to row data

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.

Tags (1)
1 Solution

Accepted Solutions
qlik4asif
Contributor II

Re: How to convert column data to row data

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)

));

View solution in original post

5 Replies
srinu1331
New Contributor III

Re: How to convert column data to row data

Using through CrossTable Concept

Highlighted
qlik4asif
Contributor II

Re: How to convert column data to row data

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
Contributor II

Re: How to convert column data to row data

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)

));

View solution in original post

qlik4asif
Contributor II

Re: How to convert column data to row data

Capture.PNG

Hope i have answered ur question:)

Partner
Partner

Re: How to convert column data to row data

Hi,

Browse input data

click on Enable Transformation step -> Rotate -> Transpose

Columns to rows.JPGColumns to rows.JPG

Regards

Sahadev