Record Dropped
Moderators: chulett, rschirm, roy
Record Dropped
Hi,
I am having a small job where i am having Null values which is passed through Transformer and then to Sequential file.I have handled Null values in the stage variables in transformer like IsNUll(Column),NullTOValue(),NullTOZero(),Column='', but still getting the below error.
"APT_CombinedOperatorController(2),0: Field 'copysno' from input dataset '0' is NULL. Record dropped."
The problem is in the transformer as i have handled Null values for Sequential file.
Can any please provide me the solution for this issue.
Thanks in Advance
I am having a small job where i am having Null values which is passed through Transformer and then to Sequential file.I have handled Null values in the stage variables in transformer like IsNUll(Column),NullTOValue(),NullTOZero(),Column='', but still getting the below error.
"APT_CombinedOperatorController(2),0: Field 'copysno' from input dataset '0' is NULL. Record dropped."
The problem is in the transformer as i have handled Null values for Sequential file.
Can any please provide me the solution for this issue.
Thanks in Advance
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
Re: Record Dropped
Yes. I checked with Datatype "Double" also.soumya5891 wrote:Is the field on which you are checking null is varchar ?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I disabled operator combination.I got the below error.
Transformer_40,0: Field 'sourcerow' from input dataset '0' is NULL. Record dropped.
I am getting the error in the transformer , but i tried using Null handling functions but still getting the error.
Any help is really appreciated.
Thanks in advance
Transformer_40,0: Field 'sourcerow' from input dataset '0' is NULL. Record dropped.
I am getting the error in the transformer , but i tried using Null handling functions but still getting the error.
Any help is really appreciated.
Thanks in advance
-
- Premium Member
- Posts: 72
- Joined: Mon Jul 06, 2009 9:34 pm
- Location: Sydney
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Exactly same when there is no empty characters coming from input link. In this case it will leave the empty character as it is and replace nulls with 1.ray.wurlod wrote:... which is exactly the same as NullToValue(DSLink18.copysno,1)
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)
-
- Participant
- Posts: 132
- Joined: Wed Mar 01, 2006 11:12 pm
- Location: Pune
Re: Record Dropped
You write you are performing your null handling in a stage variable - so do you make sure to either use the result in a constraint on the output link or as input to your derivation?
_________________
- Susanne
- Susanne