Mutliple Filters

[aaceto1]

Hello,

Please see the attached sample data as I cannot provide the data I am working on since it is confidential.

The output tab is what I am working towards.

Ultimately, I am trying to filter out blank items in the LE Column as well as the Population Column, but need to keep 00009A and 00009C on the item # column even if the other two columns are blank. 

[binuacs]

@aaceto1 you can use the data cleansing tool and select the remove null rows 

[aaceto1]

That didn't seem to work because although the other two columns may be blank, if they contain the item numbers of 009999A or 009999C the rows need to remain.

[binuacs]

@aaceto1 Can you update your input file  , the above result was created based on your input file and output file

[aaceto1]

What should I update? The first tab is the input the second tab is the output. I want to remove blank rows for LE and and Population, but keep the blanks in the population if the item number is reflecting 009999A and 009999C.

[binuacs]

@aaceto1 the alteryx output is the same as the expected output you provided, am I missing something?

[aaceto1]

I don't have the same options you listed.

[binuacs]

@aaceto1 another way with the filter tool