System variable @INROWNUM compare with decimal
Posted: Thu Nov 13, 2003 2:51 pm
Hi all,
I am trying to test the variable @INROWNUM in a transformer stage against a number like the following:
If (@INROWNUM <= 300000) Then "2003-12-21" else if (@INROWNUM < 600000) And @INROWNUM > 300000) Then "2003-12-28" else "2004-01-04"
. The job works fine but even if 900 000 rows are being processed. They all get the first option ("2003-12-21") like the row number never goes over 300 000. I tried a lot of variations like putting my number inside quotes or doing a StringToDecimal() on my arguments but it's still the same. Has any of you tried to use @INROWNUM inside a transfomer and if so, how can you access it's numerical value?
Thanks
Mat
I am trying to test the variable @INROWNUM in a transformer stage against a number like the following:
If (@INROWNUM <= 300000) Then "2003-12-21" else if (@INROWNUM < 600000) And @INROWNUM > 300000) Then "2003-12-28" else "2004-01-04"
. The job works fine but even if 900 000 rows are being processed. They all get the first option ("2003-12-21") like the row number never goes over 300 000. I tried a lot of variations like putting my number inside quotes or doing a StringToDecimal() on my arguments but it's still the same. Has any of you tried to use @INROWNUM inside a transfomer and if so, how can you access it's numerical value?
Thanks
Mat