Discussion board where members can get started with Qlik Sense.
I tried to transpose a complex table as follows. But I did not get the right results through generic load also crosstable for such constructs.
What is the best practice for those challenges?
E.g.: Source table:
Thank you for help!
Go to Solution.
Of course generic / crosstable loads are very useful tools but I think not suitable in your case and that 2 normal loadings will be sufficient to get your target table. I mean something like this:
load Topic, [Case 1] as Case, AttrC1_1 as Value1, AttrC1_2 as Value2, DescC1 as Value3
load Topic, [Case 2] as Case, AttrC2_1 as Value1, AttrC2_2 as Value2, DescC2 as Value3
Thank you Marcus for fast response.