Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
This might be too easy to put on the forum but I'm in a bit of a rush. Would be grateful for a helping hand.
I've got a table such as this:
Name | A | B | C |
---|---|---|---|
Jack | 50 | 100 | 150 |
Jill | 25 | 50 | 75 |
I need to transform this table at load time to look like this:
Name | Value | Type |
---|---|---|
Jack | 50 | A |
Jack | 100 | B |
Jack | 150 | C |
Jill | 25 | A |
Jill | 50 | B |
Jill | 75 | C |
Here's the inline code for the input table:
Table1:
Load * inline [
Name,A,B,C
Jack,50,100,150
Jill,25,50,75
];
Thank you, guys!
Sam.
Hi Sam,
This should work:
Table1Final:
CrossTable (Type, Value)
Load * inline [
Name,A,B,C
Jack,50,100,150
Jill,25,50,75
];
The resulting table should have three fields, Name, Type and Value, and values in rows transposed.
Hope that helps.
Miguel