Removing [Null] rows in output data

[lancegoh1]

Hello,

my data ended at  Record # 1084573, but it seems that my output inserted additional blank rows. are there any tools that allows me to remove the blank rows? from  row # 1084574 onwards?

thank you!

Lance

[choudma7]

Hi, 

Two ways are there: 

1 In Data cleansing tool we can use "Remove Null Values".

2 In another approach we can create one new column by concatenating all cols values and check 

on concatenated values whether the result is null or not. 

Steps are like : 

1. concat_col= col1+ col2 + col3 + col4      : if any col is numeric/floor  convert them to char using TOSTRING(Var).  

2 check in filter if isempty(concat_col) 

Please see attached packaged for more information..

Manoj