Remove Null Rows

saachitalwar

I have data in the form

h1      h2     h3     h4      h5     h6     h7    file name

a        b        c       d       e        f       g       fgghhg.xlsx

[Null] [Null] [Null] [Null] [Null] [Null] [Null] fgghhg.xlsx
[Null] [Null] [Null] [Null] [Null] [Null] [Null] fgghhg.xlsx
[Null] [Null] [Null] [Null] [Null] [Null] [Null] fgghhg.xlsx
[Null] [Null] [Null] [Null] [Null] [Null] [Null] fgghhg.xlsx

I need to keep the rows with data and remove the null rows

I tried using the data cleansing tool, unselected filename and selected the rest then selected remove null rows. It is removing all the data rows but not the null rows somehow.

binu_acs

@saachitalwar because your file name field is not NULL the data cleansing tool will not work , create a flag using a formula tool and filter it out if your fields are not dynamic

IF IsNull([Field1]) AND IsNull([Field2]) AND IsNull([Field3]) AND NOT IsNull([File Name]) THEN FALSE ELSE TRUE