Solved: Transform table - Qlik Community

Report Inappropriate Content · ‎2012-09-19

I would like to transform my table in Green to get the table in Red.

I tried with a crosstable but didn't succeed. Anyone can help me ? Thank you.

rwunderlich · ‎2012-09-25

Just specify the 3 fields you want to transform in the generic.

generic load EC, KZID, Wert resident original_v2;

What you do from there depends on what you want to do with the Jahr & Quartal fields. Do you want a row for each EC/Jahr/Quartal value wth the KZID fields repeated?

-Rob

View solution in original post

Report Inappropriate Content · ‎2012-09-19

Please, upload the file again. Don´t see the image.

Report Inappropriate Content · ‎2012-09-19

I've uploaded the xlsx file, image doesn't upload. Thank you.

Report Inappropriate Content · ‎2012-09-19

Can you send a script code?

A regard.

Report Inappropriate Content · ‎2012-09-19

I've uploaded the qvw. Many thanks.

IP

Report Inappropriate Content · ‎2012-09-19

I send a probably solution?

A regard.

Report Inappropriate Content · ‎2012-09-19

Hello,

No I would like to transform this table, without joining it... but thank you for your answer!

Regards,

IP

Report Inappropriate Content · ‎2012-09-19

Take a look.

Report Inappropriate Content · ‎2012-09-19

Thank you, but I have to do that in script...

Peter_Cammaert · ‎2012-09-19

How about this one? I don't think any other solution - object or script - would be able to handle unpredictable KZID values in a simple manner.

Peter

Transform table

Related Topics