Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Complicated crosstable

Hi Community,

I have a slightly hard cross table transformation that I need to do.

Lets say I have the below table:

IDFieldA.1FieldA.2FieldA.3FieldB.1FieldB.2FieldC.1
1abcrty

And I want to transpose that to:

IDCaseField1Field2Field3
1Aabc
1Brt
1Cy

Is that possible in any kind of way?

Take into account that the number of Columns in each case are not fixed so I can have case 1 with 10 fields and case B with 1.

Any help appreciated.

Tags (1)
3 Replies
MVP & Luminary
MVP & Luminary

Re: Complicated crosstable

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable

Re: Complicated crosstable

Hi Gysbert you are really helpful,

Is there any way to have the data table exactly as the straight table is instead of making the dimension horizontal?

It would be really easier for calculations.

MVP & Luminary
MVP & Luminary

Re: Complicated crosstable

Yes, you can add the keyword GENERIC before the word LOAD in the second load statement in the script.


talk is cheap, supply exceeds demand