Is generic prefix a eligible feature for complex tables?

[Anonymous]

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

[marcus_sommer · Accepted 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:

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]

Thank you Marcus for fast response.

Best regards