Hi
In the transformer stage I introduced one new column(TMMBR_F) which has a derivation like if TMMBR_ADJ_A > 0 then 'Y' else 'N'.
In the input link to Transformer stage I am getting 100 rows in the output link from TRNS stage I am only getting 10 rows why is that..
Please throw some lights on this.
Thanks
Madhav.
Introducing New column in the Transformer Stage
Moderators: chulett, rschirm, roy
Hi Madhav,
You have to handle null values for 'TMMBR_ADJ_A'.
You can use nulltovalue or use the if then else loop to check if the value is null or the value > 0 and provide appropriate values. Beacuse of nullablity 90 rows have been dropped from the input dataset.
HTH
--Rich
Pride comes before a fall
Humility comes before honour
You have to handle null values for 'TMMBR_ADJ_A'.
You can use nulltovalue or use the if then else loop to check if the value is null or the value > 0 and provide appropriate values. Beacuse of nullablity 90 rows have been dropped from the input dataset.
HTH
--Rich
Pride comes before a fall
Humility comes before honour
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 75
- Joined: Tue May 13, 2003 4:14 am
- Location: California
- Contact:
Hi,
When ever you are using a function on an input column which is nullable,
it is better you handle nulls explicitly. Otherwise the records would be dropped when ever a null is encountered in that field.
As rightly pointed in above mails you can use IsNull or NullToValue functions to trap nulls.There are some morw functions available in the Transfomer Editor for null handling. You can use any of them as per your need.
Even IsNotNull would also help.
When ever you are using a function on an input column which is nullable,
it is better you handle nulls explicitly. Otherwise the records would be dropped when ever a null is encountered in that field.
As rightly pointed in above mails you can use IsNull or NullToValue functions to trap nulls.There are some morw functions available in the Transfomer Editor for null handling. You can use any of them as per your need.
Even IsNotNull would also help.
Happy DataStaging