Sequence no column in transform stage

femil · Post by **femil** » Sat Nov 07, 2009 10:16 am

how to create a sequence value for a column in transform stage?

chulett · Post by **chulett** » Sat Nov 07, 2009 10:30 am

Depends on what you need it for and what it needs to start from. Simplest way is the @IN/OUTROWNUM system variables. There's also the KeyMgmt routines in the sdk branch. The former starts at 1 but can be given an offset that you increment by them, the latter keeps track per 'object' tracked and each call gets you the next value.

femil · Post by **femil** » Sat Nov 07, 2009 10:41 am

can i simply type @IN/OUTROWNUM in the value field of the output column

of transform stage?

chulett · Post by **chulett** » Sat Nov 07, 2009 11:10 am

Yes. Sorta. Check the ellipsis (...) in the editor for System Variables and you'll find there are two of them: @INROWNUM and @OUTROWNUM and it's important to understand the difference between them.

femil · Post by **femil** » Sat Nov 07, 2009 11:18 am

thank you craig...