Mutliple Filters

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.

Sample Alteryx Question.xlsx

Datasets

Developer Tools

Accepted answers

All comments

binu_acs

@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.

binu_acs

@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.

binu_acs

@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.

binu_acs

@aaceto1 another way with the filter tool

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335