topic Re: Transpose Cols in QlikView

Transpose Cols

raadwiptec — Sat, 16 Nov 2024 04:32:48 GMT

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

Re: Transpose Cols

marcus_sommer — Wed, 06 Feb 2019 16:21:26 GMT

Take a look on this: The-Crosstable-Load

- Marcus

Re: Transpose Cols

raadwiptec — Thu, 07 Feb 2019 10:03:07 GMT

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

Re: Transpose Cols

marcus_sommer — Thu, 07 Feb 2019 10:38:52 GMT

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