I’ve used the Groupby node to aggregate all the different types of transport in a city all into a column containing 1 list.
Now I’m hoping to remove any rows that have the value “Car” in the list. I’ve been trying to do this through Rule-Based row filter, but with no luck so far.
As @knimediger has said, you could find a way of filtering the list first, but you would need to find all cities for which a vehicle type is car, and then do an “anti-join” using that list of cities to remove all rows for cities where at least one row is “Car”.
I’d have used “Unique concatenate” in the GroupBy and then a Row Filter, but that’s because I didn’t know that the filter works on lists. Now I know what that checkbox is for!