Removing Rows based on Condition

[knobsdog]

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

123	Good	1
123	Doesn't Matter	0
245	Good	1
245		0
123	Big	0
123	Go	0
123	Late	0

[TheOC]

hey @knobsdog 

You can do this with a filter tool:

Just continue your workflow, or output from the 'T' or 'True' output of the tool.

Hope this helps,
TheOC

[Qiu]

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

[knobsdog]

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.

[TheOC]

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