Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have a slightly hard cross table transformation that I need to do.
Lets say I have the below table:
ID | FieldA.1 | FieldA.2 | FieldA.3 | FieldB.1 | FieldB.2 | FieldC.1 |
1 | a | b | c | r | t | y |
And I want to transpose that to:
ID | Case | Field1 | Field2 | Field3 |
1 | A | a | b | c |
1 | B | r | t | |
1 | C | y |
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.
See attached qvw.
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.
Yes, you can add the keyword GENERIC before the word LOAD in the second load statement in the script.