Convert a table

[Hunky_Cat]

Hi, I need to convert a table from left image to right.

I tried using code from https://community.qlik.com/t5/QlikView-App-Dev/crosstable-reversed/td-p/446395

But it's not working because of the '/' I suppose. Could you help find a way to solve this?

[hic]

Use

Crosstable (class, feature)
Load SKU, "a/q", "b/q", "c/e", "d/r", "e/t", "f/y" From ...

See also https://community.qlik.com/t5/Design/The-Crosstable-Load/ba-p/1468083

[Hunky_Cat]

Thank you for your advice, but I need exactly the opposite of what the cross table does

[MarcoWedel]

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptP...

[Hunky_Cat]

Generic will give me 3 separate tables, I need just one combined. And I have much more data so It has to be some sort of cycle

[Sabrina_V]

https://community.qlik.com/t5/Design/The-Generic-Load/ba-p/1473470

[MarcoWedel]

Those tables can be merged, e.g. like this:

https://qlikviewcookbook.com/2010/05/use-cases-for-generic-load/#:~:text=If%20you%20want%20to%20merg...