Requirement like PIVOT

senthilmp · Post by **senthilmp** » Thu Apr 09, 2009 1:54 am

Hi,

Currently am trying to do the following:

Have source data as follows:

ID Name FYM Qty Sales
1 A 200901 1 500
2 B 200902 5 1000
3 C 200901 4 150
4 D 200902 2 252
5 E 200903 9 785
6 F 200903 7 451
7 A 200902 4 410

I have to load into target as below:

ID Name 200901Qty 200901Sales 200902Qty 200902Sales 200903Qty Sal
1 A 1 500 4 410
2 B 5 1000
3 C 4 150
4 D 2 252
5 E 9 785
6 F 7 451

i.e the Qty and Sales should come under the specic FY column defined for the ID/Name,
Can you help me out how can i do this in Pivot stage?

ray.wurlod · Post by **ray.wurlod** » Thu Apr 09, 2009 7:23 am

You can not. It's a vertical pivot. A Search for that term will yield a number of solutions, particularly for server jobs.

Moderator: please move to server forum

senthilmp · Post by **senthilmp** » Thu Apr 09, 2009 7:30 am

Ok thanks, and i posted this message in server Forum only, dont no in which forum its currently in

ray.wurlod · Post by **ray.wurlod** » Thu Apr 09, 2009 7:33 am

No, you posted in the Enterprise Edition forum, but marked the job type as server. That's not the same thing as posting in the Server Edition forum.