Forum Discussion
delete table rows where value is null
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
Hi talhaparvaiz ,
In Query Editor, click button at the column header and click Remove Empty feature.
Best Regards,
Jay
3 Replies
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
talhaparvaiz , go to query editor and filter the City column and unselect the nulls in the dropdown.
Hi talhaparvaiz ,
In Query Editor, click button at the column header and click Remove Empty feature.
Best Regards,
Jay
