Filter rows of Expanded Columns

[Anonymous]

I am trying to remove some of the rows in my data set and have already filted one of my tables to only show 2020 data but there are 2 more tables that are related to the work_order table that i am trying to filter these as well.  When i go to expand the columns and then filter for only 2020 it takes a long time and then times out. 

Is there a way to filter these without expanding the columns?

[edhans]

I don't think so - you can use functions to get the values from inside those fields, but I don't think that will be any faster than expanding that field. 

[lbendlin]

That very much depends on what question you are trying to address with your data.  Of course you can filter these tables before adding them to this one, but ony you can tell if that is appropriate or would lead to information loss.

In other words, this needs more context.