Pivot Up while loading data

Mon, 24 Jun 2013 14:04:30 GMT

I have my data source table in this format:

and while loading the data in QV I want to load it in the following format:

Any ideas?

Re: Pivot Up while loading data

Mon, 24 Jun 2013 16:08:15 GMT

T1:

LOAD * INLINE [

CustomerID, CategoryType, CategoryValue

1, A, A1

2, A, A2

3, A, A3

4, A, A4

1, B, B1

2, B, B1

3, B, B2

4, B, B3

1, C, C1

2, C, C2

3, C, C3

4, C, C4

5, C, C1

];

T2:

LOAD

CustomerID,

MaxString(If(CategoryType = 'A', CategoryValue)) AS A,

MaxString(If(CategoryType = 'B', CategoryValue)) AS B,

MaxString(If(CategoryType = 'C', CategoryValue)) AS C

Resident T1

Group By CustomerID;

DROP Table T1;