Removing rows with Null values from a specific column

[Hoss2434]

Hello I am struggling to find a method to remove rows that contain rows from a specific column. Here is a before and after of what I am looking for.

Before:

#	column1	column2	column3
1	value1	value2	value3
2	value1	value2	null
3	null	value2	value3
4	value1	value2	null

After:

#	column1	column2	column3
1	value1	value2	value3
3	null	value2	value3

So in this example, only rows from column 3 that contain nulls were removed. So only rows 2 and 4.

Any help would be appreciated.

Thank you!

[ShankerV · Accepted solution]

Hi @Hoss2434 

One way of doing this!!!

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Hoss2434 

On the other had, if you really have the word as null.

Then this filter will help.

Many thanks

Shanker V

[MilindG]

One way to do this

[martinson]

Attempt 1