Removing rows with specific condition on excel output

Hi everyone,

Im trying to remove the rows where a condition is met. This runs every day and just need to keep the ones without the Y and keep the others. For instance:

Input file sheet1 (same as the output file for current day):

Name	Iphone
Mike	N
Richard	Y
Peter
John	Y

the same sheet should be overrided and the output must be (sheet1):

Name	Iphone
Mike	N
Peter

Appreciate all the help!

Output

Accepted answers

DataNath

Hey @ricardoestradah, to remove the 'Y' entries, you can just use a Filter tool like so:

To then Output your result, ensuring that you overwrite the existing file, just use the same configuration as shown here (obviously selecting the input file as the output to then overwrite):

Overwrite sheet with conditional output.yxmd

All comments

DataNath

Hey @ricardoestradah, to remove the 'Y' entries, you can just use a Filter tool like so:

To then Output your result, ensuring that you overwrite the existing file, just use the same configuration as shown here (obviously selecting the input file as the output to then overwrite):

Overwrite sheet with conditional output.yxmd

ricardoestradah

Thanks that worked !

ricardoestradah

Thanks, that worked!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703