Filter whole table


is there a simple way to filter the whole table by value? I mean, just keep the columns and rows where a wildcard match is true. If I firstly keep the columns and then run a ruled-based filter row, it’s ok, but is there a way to filter all the columns that have some cells that fulfil the condition? (in my case, LIKE “-R”)

Hello @jquadrada
A simple solution is to use a standard ‘Row Filter’ node:

But how I filter all the columns at once? I mean, if I filter one column, keeping only the values that fulfil the matching criteria, I could miss other values that appear in other columns…

OK, I answer myself:

I concatenate all the values in a new colum and execute row filter on that column :wink:

1 Like

Your solution by itself doesn’t accomplish the full statement for the challenge, as you are only filtering rows

just keep the columns and rows […]

I guess a Loop over column condition to identify LOGIC -that filter does return empty-, then remove the TRUE columns…

Use a numpy array in python snippet

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.