Filter Rows of Data Based on a Field

[Kristie_Pires]

Hello community! 

I am trying to find a way to filter out my data based on rows. For example, ID 1222 has a comment of "Forced Closed"; therefore, I would remove the ID from the report. Same thing with ID 1233 that was created in error. 

Before:

ID	Stage	Comment
1222	Initial	Forced Closed
1222	Second
1233	Initial
1233	Second	Created in Error
1244	Initial
1244	Second

ID	Stage	Comment
1244	Initial
1244	Second

[acarter881 · Accepted solution]

Hello, @Kristie_Pires.

Here is one method for achieving this (see attached workflow).

[ChrisTX · Accepted solution]

Use a Join tool and continue processing only the Left output anchor.

Chris

[nagakavyasri · Accepted solution]

Another way:

[Kristie_Pires]

Thank you all for your help! I ended up using @acarter881 solution as the comment could change and I wanted to try the multi-Row formula 😊