Dear expert,
I want to remove all rows where specific column/column values are blank
Field1 | Filed2 | Filed3 | Filed4 |
attr1 | |||
attr1 | attr2 | attr5 | |
attr1 |
for above eg I want to remove row 1 and row 3.
can you please share some solution, please note that number of rows can vary
Solved! Go to Solution.
Hello @Avishek1
You could use the data cleansing tool here. First use a select tool to only keep the fields that you want to check for all null values in then use the data cleansing tool making sure to check the Remove null rows check box.
Hey @Avishek1 !
Looks like you can use a simple filter.
Select the field2 and "is not null"
If need to do for more columns, use customized with formula like:
isnull(f[field1]) or isnull([field2])
Hope that help!
Hi @Avishek1
One easy way is using a filter that looks at if all of the fields are empty
e.g., IsEmpty([Field2]) AND IsEmpty([Field3]) etc.
Cheers!
Esther
@Kenda Thanks for your response actually I need the first coulmn to be in my output hence if I am performing the solution provided I am losing 1st column information
Just be sure to use the boolean AND in the custom filter, otherwise you can wind up filtering out any row where a field is empty.
Cheers!
Esther