How to transpose values from a table and group them by a field?

Wed, 24 Jul 2013 21:00:38 GMT

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:

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.

Re: How to transpose values from a table and group them by a field?

Miguel_Angel_Baeyens — Wed, 24 Jul 2013 21:06:02 GMT

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