delete table rows where value is null

[talhaparvaiz]

Hi,

I have a table that when imported, reads something like this

Country      City

Canada      Toronto

Canada      

Canada      Calgary

Canada      Vancouver

I want to delete rows from this table (at data refresh) where City is null... so that my final table should look like this

Country      City

Canada      Toronto

Canada      Calgary

Canada      Vancouver

Thanks

[Anonymous · Accepted solution]

Hi @talhaparvaiz ,

In Query Editor, click button at the column header and click Remove Empty feature.

Best Regards,

Jay

[Anonymous]

@talhaparvaiz , go to query editor and filter the City column and unselect the nulls in the dropdown.   

[VijayP]

@talhaparvaiz 

in Power Query editor you can remove the such rows

watch this short video https://drive.google.com/file/d/1joxWn6FCWlXJ_SdVkZkOCZKUVUezvhti/view?usp=sharing