Delete Attribute with Specified Number of Zero Value

Hi All

I need a guide on how to delete an attribute which have specified number of zero value. Let say I have an example set as below and I want to delete attribute that have three zero value (in this case I want to delete column A and B while retain column C)

A 0.0	B 0.01848	C 0.00308
0.0	0.0	0.0
0.00793	0.0	0.0
0.0	0.0	0.00648

Appreciate if anyone can guide me which operator that can do the job.

Thank you.

Find more posts tagged with

AI Studio

Accepted answers

lionelderkrikor

Hi @yeopputra,

I have an approximative solution.
You can find a process where the attribute(s) with strictly more than 2 "0" values are removed.
You can adapt this process to your use case by setting the value of the macro (in the Set Macros operator).

hope this helps,

Regards,

Lionel

Count_missing.rmp

All comments

lionelderkrikor

Count_missing.rmp

MartinLiebig

Hi,

check the operator Filter examples with Missings, which is part of operator toolbox.

BR,

Martin

yeopputra

Hi @lionelderkrikor

Thanks for the reply. Yes. The process works for me. Thanks again.

yeopputra

Hi @mschmitz

Thanks for the reply. I will try this step too later. Thanks.