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

Question

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.

15.PNG

New Workflow2.yxmd

DavidP · Answer

Hi @swarajjoshi

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

Emil_Kos · Answer

Hi @swarajjoshi ,

I have prepared a workflow for you:

And the output:

If helpful please mark my post as a solution.

Good luck!

Filter.yxmd

atcodedog05 · Answer

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 😀👍

New Workflow2.yxmd