topic Re: Transform Rows to Columns in QlikView

Transform Rows to Columns

phil-ebm — Wed, 13 Apr 2016 09:33:29 GMT

Hi @All

I have following Data-Table (1.5 Million Rows)

and i want to transform this into this

during the load in my datamodel:

I've tried it with Transformation -> Rotate (here it rotates the whole table but i only want to rotate the two marked columns) and Crosstable and couldn't find the right solution.

Then i found this way. Creating the Table Step by Step.

CAT:
LOAD ID_ARTIKEL as %KeyArtikel,
  MERKMAL as BAUGR
FROM
  [..\..\..\..\..\Data\epM\PROD1\qvd\CAT_MERKMAL.qvd](qvd)
WHERE CAT_KUZEI = 'BAUGR';

left join(CAT)
LOAD ID_ARTIKEL as %KeyArtikel,
  MERKMAL as CE
FROM
  [..\..\..\..\..\Data\epM\PROD1\qvd\CAT_MERKMAL.qvd](qvd)
WHERE CAT_KUZEI = 'CE';

It's working but i'm not satisfied with this because i have to do this for every record in CAT_KUZEI and there are 462 distinct Values

Have someone here a sample or solution how i can transform my table to the right structure?

Thanks & Regards

Philipp

Re: Transform Rows to Columns

Chanty4u — Wed, 13 Apr 2016 09:35:46 GMT

chk dis

Cross Table Load

Re: Transform Rows to Columns

petter — Wed, 13 Apr 2016 09:38:33 GMT

Cross Table is in the opposite direction - transforming rows to columns.

Re: Transform Rows to Columns

Kushal_Chawda — Wed, 13 Apr 2016 09:39:11 GMT

Generic load will be helpful in this case

The Generic Load

Re: Transform Rows to Columns

petter — Wed, 13 Apr 2016 09:40:52 GMT

The technique that dathu.qv‌ shows in this article should suit your needs fine: Re: Any alternate to Generic load? His suggestion is NOT a generic load but use GROUP BY.

Re: Transform Rows to Columns

phil-ebm — Wed, 13 Apr 2016 11:27:16 GMT

I never heard from the Generic Load but it was exactly what i wanted.