topic Convert columns to rows in QlikView

Convert columns to rows

Wed, 16 Feb 2011 11:08:31 GMT

Hello together,

I import a table from a database which looks like this:

Contact Line Number

1 10

1 20

1 30

2 10

2 20

But now i want to convert die Rows in columsn that the table looks like this:

Contact Line Number 1 Line Number 2 Line Number 3

1 10 20 30

2 10 20 -

The Command in the Script is:

Load

Contact No,

Line No;

FROM Table ABC

Hope you can help me! Thanks a lot!

Convert columns to rows

Miguel_Angel_Baeyens — Wed, 16 Feb 2011 11:16:35 GMT

Hello,

Check this file on how to use the Crosstable load in QlikView.

Hope that helps.

Convert columns to rows

tanelry — Wed, 16 Feb 2011 11:35:48 GMT

I think Andy needs opposite of crosstable load, which is GENERIC LOAD.

There are some examples here: http://qlikviewnotes.blogspot.com/2010/05/use-cases-for-generic-load.html

Convert columns to rows

Wed, 16 Feb 2011 11:40:35 GMT

I have tried the Crosstable Command but it doesn´t work.

The field Contact No_ isn´t found. Here the Code in the script:

I have also tried the Generic Load, but i don´t unterstand the command related to my Table..

Can you help me ?

Convert columns to rows

Anonymous — Wed, 16 Feb 2011 11:44:08 GMT

There is no field named "Contact No_" in Table Test

Convert columns to rows

Miguel_Angel_Baeyens — Wed, 16 Feb 2011 11:51:57 GMT

Hi,

Check the following sample script:

RawData:LOAD * INLINE [ID, Line1, 101, 201, 302, 102, 20]; DataTemp:LOAD ID, Pick((Line/10), 'Line 1', 'Line 2', 'Line 3') AS LineNo, Line AS LineNoContentRESIDENT RawData; DROP TABLE RawData; Data:GENERIC LOAD *RESIDENT DataTemp; DROP TABLE DataTemp;

Then create a now chart, Pivot Table, select ID as Dimension and

Only([Line 1])

Only([Line 2])

Only([Line 3])

as Expressions.

Is that what you are looking for?