Posted: Mon Dec 30, 2002 2:08 am
Hello Ranjan,
you are mixing 2 things. The pivot stage is something for pivoting. As you know excel it is about the same.
If you have a table like this:
Name Month Sum
John 04 2000
Paul 04 3000
John 05 1500
Pete 04 3400
Paul 05 6000
pete 05 5600
and you want to make a table like this:
Name SumMonth04 SumMonth05
John 2000 1500
Paul 3000 6000
Pete 3400 5600
then you should use the Pivot-Stage.
For the deployment of Jobs to an other site instead of using the import and export in manager you can also use the package installer.
Wolfgang
you are mixing 2 things. The pivot stage is something for pivoting. As you know excel it is about the same.
If you have a table like this:
Name Month Sum
John 04 2000
Paul 04 3000
John 05 1500
Pete 04 3400
Paul 05 6000
pete 05 5600
and you want to make a table like this:
Name SumMonth04 SumMonth05
John 2000 1500
Paul 3000 6000
Pete 3400 5600
then you should use the Pivot-Stage.
For the deployment of Jobs to an other site instead of using the import and export in manager you can also use the package installer.
Wolfgang