I want to select rows from columns which contain data and skip those who doesn't contain.

[swarajjoshi]

Hey guys I have 2 columns in which are Contact(Int64) and Contact Id(String), both of them contain some null records. So I want to select only those rows which contain data and don't want the rows which don't contain record.

I have attached my data below. It would look same i.e if there is data in Contact there would be data in Contact Id to.

[atcodedog05]

Hi @swarajjoshi 

you can use a filter tool and check for empty cells

!IsEmpty([Contact]) and !IsEmpty([Contact ID])

Both are empty

Here is resource on filter tool.

https://community.alteryx.com/t5/Interactive-Lessons/Filtering-Data/ta-p/76301

And is both Or is either

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Emil_Kos]

Hi @swarajjoshi ,

I have prepared a workflow for you:

And the output:

If helpful please mark my post as a solution.

Good luck!

[DavidP]

Hi @swarajjoshi 

Did you know that since version 2020.2 The Data Cleanse tool includes an option for removing null rows and columns?