DSXchange

Hi,

Could you please give me some idea of how can i perform a Vertical pivot in server jobs...

The scenario is:

Source File:

Col1,Col2
1,1
1,2
1,3
2,4
2,5
2,6
3,7
3,8
3,9

Target:

Col1,Col2,Col3,Col4
1,1,2,3
2,4,5,6
3,7,8,9

Thanks

Suresh N

I found 88 matches using the exact term "vertical pivot" and the powerful, yet user-friendly "search" function that can be found in the menu bar above this post. I'll subtract 1 from that total since it also included your post, so you have 87 exact maches and there is a very good chance that your question will be answered numerous times in those threads.

Firstly you have posted in the wrong forum. And second, a search for "Vertical pivot" in server forum returned 49 matches. See if one of them helps.