Forum Discussion

talhaparvaiz's avatar
talhaparvaiz
Helper I
5 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi talhaparvaiz ,

     

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

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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