Removing Rows based on Condition

Question

I have a workflow that needs to have all the rows deleted that have a 0 in the Good Name Added column.  I'm not sure how to remove them without losing all IDs that match.

ID                      Name                        Good Name Added

123Good1123Doesn't Matter0245Good1245 0123Big0123Go0123Late0

Delete Duplicate Rows Based on Condition Example.yxmd

TheOC · Answer

Hey @knobsdog

Sorry, not sure if I'm misunderstanding - but you don't have to do anything with the 123 in the false node, just produce your output from the true node.

If you're wanting them taken out at the input level, you will have to create a workflow that makes this filter and produces a new output - and then use that output as the input for this workflow.

Alternatively if you're doing an indb connection, you can use an indb filter.

Hope this helps,

TheOC

knobsdog · Answer

Yes that works to separate the two populations the problem is I need to show all without a good name.  So if I filter I'll still have 123 in the False node but it needs to not show b/c it does have a good name.

Qiu · Answer

@knobsdog 
Or we can use the formula directly in the Filter tool

Delete Duplicate Rows Based on Condition Example1.yxmd