Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

christiane2003
New Contributor II

Is generic prefix a eligible feature for complex tables?

Hi all,

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:

Target table:

Thank you for help!

Kindest regards

1 Solution

Accepted Solutions

Re: Is generic prefix a eligible feature for complex tables?

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:

target:

load Topic, [Case 1] as Case, AttrC1_1 as Value1, AttrC1_2 as Value2, DescC1 as Value3

from Source;

     concatenate(target)

load Topic, [Case 2] as Case, AttrC2_1 as Value1, AttrC2_2 as Value2, DescC2 as Value3

from Source;

- Marcus

2 Replies

Re: Is generic prefix a eligible feature for complex tables?

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:

target:

load Topic, [Case 1] as Case, AttrC1_1 as Value1, AttrC1_2 as Value2, DescC1 as Value3

from Source;

     concatenate(target)

load Topic, [Case 2] as Case, AttrC2_1 as Value1, AttrC2_2 as Value2, DescC2 as Value3

from Source;

- Marcus

christiane2003
New Contributor II

Re: Is generic prefix a eligible feature for complex tables?

Thank you Marcus for fast response.

Best regards

Community Browser