The Delete Empty Rows function removes the whole row where the cell of a selected column has no data.
Step 1: Select the data from the left file tree or from “files” tab which needs to be manipulated.
Step 2: Once you select the file, it will be opened in the “Data Wrangler”.
Step 3: Click on the “Delete empty rows” and a popup will appear.
Step 4: Click on the columns in which you want to apply delete empty rows under “Select data”.
Step 5: After selecting the columns, every cell of selected column of the file will be checked and if there is no data that cell will be deleted.
Step 6: The default “Result” is to overwrite the original file with the updated file.
Select what you want to save as your output file from the “output” dropdown menu.
If you want to keep the original file along with your updated file then, click on “Keep all columns” or “only keep selected columns” under “create new file”. Click “run”. The new file will be saved in the same folder as original file.