Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

raadwiptec
Contributor II

Transpose Cols

Hi 

My source data is attached. 2 tabs .sheet 1 showing the Source Data .sheet 2 showing the out put required.

so from Columns AW TO BC in excel shows the column Carieer  Ref 1 to Carieer Ref 7

BD To BJ - Columns RCC-1 to RCC-7

BK- BQ - Alloc Ref -1 to Alloc Ref -7

The above columns needs to be transposed and respective columns needs to be duplicated and categorised under 3 different columns like Carrier Ref, RCC, Alloc 

 

 

Labels (1)
3 Replies
MVP & Luminary
MVP & Luminary

Re: Transpose Cols

Take a look on this: The-Crosstable-Load

- Marcus

raadwiptec
Contributor II

Re: Transpose Cols

Hi Marcus

In the example you provided it transposes basically all the Columns other than Product. But in my case i need to transpose only certain Columns 

 

MVP & Luminary
MVP & Luminary

Re: Transpose Cols

With the order of the fields within the load-statement and the third parameter of the crosstable-statement you could specify which columns should be transposed. If there are multiple but different column-areas which needs to be transposed it might be useful to use several crosstable-statements just with certain data-parts and then to merge them afterwards together again.

- Marcus