Page 1 of 1
Specify columns in Pivot Stage
Posted: Wed Jun 30, 2004 12:05 am
by Sreenivasulu
Hi ALL,
How to specify two input columns ( syntax) in the "derivation" tab of a pivot stage. I could not find this in the documentation of datastage.
Regards
Srini
Posted: Wed Jun 30, 2004 12:43 am
by girishoak
HI Srini,
do you want to know, how to use to columns in derivation in an output tab? I couldnt understand
How to specify two input columns ( syntax) in the "derivation"
. Please elaborate on this.
If you want to use two columns coming from input in an output tab, you can use them as column1,column2.
All the best
Girish Oak
Posted: Wed Jun 30, 2004 1:05 am
by Sreenivasulu
Hi Girish,
Your suggestion really helped. Thanks a lot.
Regards
Sreenivasulu
Posted: Wed Jun 30, 2004 2:19 am
by ray.wurlod
The Pivot stage manual is called pivot.pdf. It is in the Packages folder on your DataStage CD. Because you are on 7.x, it should have been installed in your DataStage clients' documentation folder (by default this is C:\Program Files\Ascential\DataStage\Docs).