Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
marcus_sommer

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

View solution in original post

2 Replies
marcus_sommer

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

Anonymous
Not applicable
Author

Thank you Marcus for fast response.

Best regards