Excluding a single result from a column

[EilidhIsla]

What I’m trying to do

I have a dataview query that fetches all notes that have a value of Foo in a Property (List type) called Organisations. One of the columns lists Organisations. However, I wish to remove Foo from the list of Organisations output in the table.

Things I have tried

With this query:

table without id
file.link as Name, join(Organisations) as Organisations
where contains(Organisations, [[Foo]])
sort file.name asc

Current output:

Name | Organisations
Person 1 | Organisation 1, Organisation 2, Foo
Person 2 | Organisation 1, Foo

Desired output:

Name | Organisations
Person 1 | Organisation 1, Organisation 2
Person 2 | Organisation 1

[holroy]

Try something like join(filter(Organisations, (o)=> o != "Foo")), and see if that doesn’t solve your issue.

[EilidhIsla]

Solved, many thanks indeed. I really appreciate you taking the time.