Forum Discussion

lucilach's avatar
lucilach
New Member
6 years ago

FILTER into new table, compare columns

Hello
I would like to use FILTER to create a new table filtering the rows by a comparison. According to documentation, FILTER is a "function that is embedded in other functions that require a table as an argument". What function should I use to get this table as a result?

Also, I'm having trouble making the boolean expression of comparison. I have two columns called Count and Max. I want to keep only the rows where the value of Count is the same as the value of Max. I only know how to compare a value in a column to a given value.

 

2 Replies