Transpose and change title

[#1]

Hello Community,

I am new with qlikview and have a problem to transpose row contends in columns with a fixed title (SAP import).

Import from SAP:

Article	Scale	Amount
Test1	1.000	120
Test1	2.000	115
Test1	5.000	112
Test1	10.000	111
Test1	20.000	100
Test2	2.000	224
Test2	4.000	220
Test2	10.000	228
Test2	20.000	222
Test2	40.000	218
Test3	1.000	50
Test3	2.000	48
Test3	5.000	46
Test3	10.000	45

should look like: scale and amount side by side, the number of scales could be different

Article	Qty. 1.scale	Am. 1. Scale	Qty. 2.scale	Am. 2. Scale	Qty. 3.scale	Am. 3. Scale	Qty. 4.scale	Am. 4. Scale	Qty. 5.scale	Am. 5. Scale
Test1	1.000	120	2.000	115	5.000	112	10.000	111	20.000	100
Test2	2000	224	4000	220	1000	228	20000	222	40000	218
Test3	1.000	50	2.000	48	5.000	46	10.000	45	-	-

i tried some reasons but never get the correct result.

Thank you, Norbert

[ariel_klien]

Hi,

Please See if the Attachment help you.

BR

Ariel

[Gysbert_Wassenaar · Accepted solution]

There's the easy way (recommended and ignoring the title labels) and the hard way (bad idea). See attached example.

[#4]

Hi Ariel,

thanks for your fast Answer, but the import is from SAP with ca 350.000 lines and i have no field "NO" and no possibility to add it manually.

BR Norbert

[ariel_klien]

See how Gysbert create RowNo()....

[#6]

It takes a little to load the data, but the result is perfect!!

Thanks a lot for your answers!!