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.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- 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