Specify columns in Pivot Stage

Sreenivasulu · Post by **Sreenivasulu** » Wed Jun 30, 2004 12:05 am

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

girishoak · Post by **girishoak** » Wed Jun 30, 2004 12:43 am

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

Sreenivasulu · Post by **Sreenivasulu** » Wed Jun 30, 2004 1:05 am

Hi Girish,

Your suggestion really helped. Thanks a lot.

Regards
Sreenivasulu

ray.wurlod · Post by **ray.wurlod** » Wed Jun 30, 2004 2:19 am

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).