Saturday, 1 September 2012

How to remove Null values using Filter Transformation?

In the Filter Transformation you can filter out rows having null values and spaces by using ISNULL and IS_SPACES functions.
For example , to filter out rows that contain null in EMP_NAME column us the below condition
This condition says that if the Employee name is null then discard the row else pass it to the next transfomation

1 comment:

  1. you could also use the filter condition NOT ISNULL(EMP_NAME)


Related Posts Plugin for WordPress, Blogger...