The Filter Rows block

Keep the rows that match · in code: Filtering a List

What it does

Makes a new list of only the rows (or items) that match a condition, like the students who scored above 80.

Use it for

The toppers: row.marks > 80.
One department: row.dept == "CSE".
The passing marks in a list of numbers: m >= 50.

What to fill in

From: The list to go through, like students.
Call each row: The name each row has in the condition, like row. It's only used there.
Keep it when: A condition that's true for the rows to keep: row.marks > 80.
Put them in: The name of the new list, like toppers. The list it came from stays as it was.

Try it

Open it in the editor, press Run, then change it and run it again.

ExamplePassing marks Try it

Start
Create marks = [45, 80, 62, 30, 91]
Tell "Passed: " + join(passed)
End

It showsPassed: 80, 62, 91

1marks = [45, 80, 62, 30, 91]2passed = []3for m in marks:4    if m >= 50:5        passed.append(m)6print("Passed: " + ", ".join(str(item) for item in passed))

Tips

It looks at one row per step, so Step through it and watch which rows are kept.
It does what a For Each with a Decision and Change a List does: View Code shows that loop.
The kept rows are the same rows, so changing one with Change a Field changes it in the first list too.

Learn it in lesson 10Filter and sort: work with tables

Goes with

Sort Rows