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
Solved! Go to Solution.
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