Page 1 of 1
Sequence no column in transform stage
Posted: Sat Nov 07, 2009 10:16 am
by femil
how to create a sequence value for a column in transform stage?
Posted: Sat Nov 07, 2009 10:30 am
by chulett
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.
Posted: Sat Nov 07, 2009 10:41 am
by femil
can i simply type @IN/OUTROWNUM in the value field of the output column
of transform stage?
Posted: Sat Nov 07, 2009 11:10 am
by chulett
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.
Posted: Sat Nov 07, 2009 11:18 am
by femil
thank you craig...