LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sree

Hi ,
In my source file, for some of the records for some columns have null values.
But when i try to read and split the records based on one field,all null records in that one column,but null records are not able to recognize by the split nde.
Please help in this.
Regards,
Sree.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

Can you post an example graph containing what you are trying to do?
Have you tried using the isNull and isNotNull BRAINscript operators within the Split node's PredicateExpr parameter?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sree

Input records
emppos code
99999 12
25
99999 25
99999 2669
99999 222
55
99999 555
99999 555
99999 1112


I want to send all rnull records to one file, other records which contains values to other file.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

Hey,

As mentioned in previous post, you can use the isNull or isNotNull BRAINscript operators.
See attached example graph.

Tim.
Attachments:
isNull.brg