FILTERING FOR ZERO VALUES

Hi,

I'm looking to create an output where it shows any rows that have a zero in that row and removes any that have a full set of values.

E.G. imagine the first row has values of 54, 10, 23, 0, 4 - i would want this to show in the output because this has a zero.

Whereas a row of 1, 2, 3, 4, 5 - i wouldn't want to show because there is no zero value.

Hope this makes sense.

Thanks,

Tom

Workflow

Datasets

Common Use Cases

Data Investigation

Accepted answers

binu_acs

@tomtingley I updated the workflow. Can you check the result and let me know how it looks

Buildings_220323.yxmd

RobertOdera

Hi, @tomtingley

Try this out.

I hope you find it helpful - cheers!

Based on your logic, the desired output is 15 rows (out of 21)...

For_tomtingley.yxzp

tomtingley

Thanks a lot, this also works!!

All comments

binu_acs

@tomtingley One way of doing this

Exclude non-zero records_220323.yxmd

tomtingley

Thanks so much! @binuacs

Would you be able to do that for me on this data set? I get duplicate rows when I try.

I've highlighted the rows with zero values that I want to show in the output.

Buildings.xlsx

binu_acs

@tomtingley I updated the workflow. Can you check the result and let me know how it looks

Buildings_220323.yxmd

tomtingley

Amazing! Thanks so much

RobertOdera

Hi, @tomtingley

Try this out.

I hope you find it helpful - cheers!

Based on your logic, the desired output is 15 rows (out of 21)...

For_tomtingley.yxzp

tomtingley

Thanks a lot, this also works!!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703