Filter based on the result of another filtering

[lity125]

Hi all, I would like to filter the records with below criteria to a new sheet (sheet 1)

1. with amount >=500 or

2. with amount >=100 and with name in the list of above criteria

Then, filter the records with below criteria to another new sheet (sheet 2)

1. with amount >=100 and

2. not in sheet 1

I stuck in filtering of sheet 1. I can filter criteria 1 but have no idea on how to filter criteria 2 that need to base on the result of criteria 1. Is there anyone can help? Thanks.

[Qiu]

@lity125 

You will need to speficy the Sheet Name when you export the result.

---

@lity125 wrote:

Hi all, I would like to filter the records with below criteria to a new sheet (sheet 1)

1. with amount >=500 or

2. with amount >=100 and with name in the list of above criteria

---

What is the name meaning?

[Qiu]

@lity125 
Maybe something like this?

[RolandSchubert · Accepted solution]

Hi @lity125 ,

if I got you right, you have to "decomposite" your conditions.

Step 1: Find the rows with Amount >= 500
Step 2: Find Unique names in the result of step 1
Step 3: Find Amount >= 100 and < 500
Step 4: Join result of steps 2+3 (should be your second condition

For the second sheet, your have to find Amount >= 100 and remove the rows already in sheet 1 ("R" output anchor of Joni tool.

I've attached a sample workflow. Let me know if it works for you.

Best,

Roland

[lity125]

@Qiu, amount and name are 2 of the columns in the file

[Qiu]

@lity125 
So it is the ID in my workflow.

Kindly check if it is what you need.