Hi
I am facing an issue with Null Values in integer field from file.
What i am doing here is I am validating the null value using
If (IsNull(lnk_In.col1) or trim(lnk_In.col1)="") Then "NULL" Else "NONNULL".
then i put condition while loading into table only to move the data when the above stage variable is "NONNULL".
However i am getting below error on null value.
Tfm_Validate,0: Field 'col1' from input dataset '0' is NULL. Record dropped.
Null Representation
Moderators: chulett, rschirm, roy
The condition as you've posted is OK and is not causing the warning/error. Somewhere else in your transform stage you are doing an operation on col1 which is triggering the message.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Although conditions are usually evaluated left-to-right and an OR condition stops evaluations once one TRUE is found, perhaps you could try
Code: Select all
If IsNull(lnk_In.col1) THEN "NULL" ELSE IF trim(lnk_In.col1)="" Then "NULL" Else "NONNULL"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: