This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have an Excel file where I had to delete rows if the field in the first column was blank. Basically it was an ID field and one of two other columns in the row had sub-totals that I needed to eliminate for my data to work in Tableau and not double count the totals.
I was able to use the Filter Tool's Basic Filter. I selected that first field from the drop down.
Then selected "Is empty" (last box is blank).
All of the rows where the first column was blank (empty) were "True" and the rows I wanted to keep were "False." I then continued the workflow with export into Tableau and it worked perfectly.