Transform Rows to Columns

[phil-ebm]

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

[Chanty4u]

chk dis

Cross Table Load

[petter]

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

[Kushal_Chawda · Accepted solution]

Generic load will be helpful in this case

The Generic Load

[petter]

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.

[phil-ebm]

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