Conditional Row filtering

[Yuri24]

Hi,

I have a data set as shown below  from which rows need to be filtered. The filter condition is multi condition where if flag is 1 for a partition (by name) then filter or select that row. However if all flag values are same then filter or pick the rows by their oldest date.

Name	Number	date	Flag
Oscar	1234567890	01/01/2011	1
Oscar	1234567890	01/01/2011	0
Jane Joe	2345678901	01/02/2011	1
Jane Joe	2345678901	01/02/2011	1
Jane Joe	2345678901	01/03/2012	0
Jane Joe	2345678901	01/03/2012	1
Don Jon	3456789012	03/03/2013	0
Don Jon	3456789012	03/04/2013	0
Bill Will	4567890123	04/05/2012	0
Bill Will	4567890123	04/06/2012	1
Banner Stark	5678901234	10/10/2020	1
Banner Stark	5678901234	10/11/2020	1
Tony Bruce	6789012345	10/20/2021	1
Tony Bruce	6789012345	10/20/2021	1

I need output so only specific rows are filter as shown below

Name	Number	date	Flag
Oscar	1234567890	01/01/2011	1
Jane Joe	2345678901	01/02/2011	1
Don Jon	3456789012	03/03/2013	0
Bill Will	4567890123	04/06/2012	1
Banner Stark	5678901234	10/10/2020	1
Tony Bruce	6789012345	10/20/2021	1

Thanks in Advance!

[gawa · Accepted solution]

hi @Yuri24 

First step is to add one more flag column to distinguish whether each Name and Number has all same flag value or not. After that, depending on this new flag value, configure filter condition as you wish. Please refer to the attached WF.

[flying008 · Accepted solution]

Hi, @Yuri24 

A dynamic solution for you , don't need formula:

Input					Output
Name	Number	date	Flag		Name	Number	date	Flag
Oscar	1234567890	01/01/2011	1		Oscar	1234567890	01/01/2011	1
Oscar	1234567890	01/01/2011	0		Jane Joe	2345678901	01/02/2011	1
Jane Joe	2345678901	01/02/2011	1		Don Jon	3456789012	03/03/2013	0
Jane Joe	2345678901	01/02/2011	1		Bill Will	4567890123	04/06/2012	1
Jane Joe	2345678901	01/03/2012	0		Banner Stark	5678901234	10/10/2020	1
Jane Joe	2345678901	01/03/2012	1		Tony Bruce	6789012345	10/20/2021	1
Don Jon	3456789012	03/03/2013	0
Don Jon	3456789012	03/04/2013	0
Bill Will	4567890123	04/05/2012	0
Bill Will	4567890123	04/06/2012	1
Banner Stark	5678901234	10/10/2020	1
Banner Stark	5678901234	10/11/2020	1
Tony Bruce	6789012345	10/20/2021	1
Tony Bruce	6789012345	10/20/2021	1

[Yuri24]

@flying008 thanks, can you please share the workflow

[flying008]

Hi, @Yuri24 

There is almost nothing to set up for the workflow here, just call the tool directly, and you can got it.