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.
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 😀👍
Hi @swarajjoshi ,
I have prepared a workflow for you:
And the output:
If helpful please mark my post as a solution.
Good luck!
Hi @swarajjoshi
Did you know that since version 2020.2 The Data Cleanse tool includes an option for removing null rows and columns?