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.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
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.