I am want to query a big table (T1) based on values in a table T2 .
The condition is - filter all the rows in T1 in which value of Col A is included in the list of values in Col B of T2. Col A is a Text Column and Col B is a Text column with a list. Col B can be an array also. This works fine when Col A has a single value.
What I need is - filter all rows in T1 in which any value in Col A is included in the list of values in Col B of T2. Here Col A is a Text Column with a list of values. This doesn’t work.
Col A cannot be an array since array is not a basic column and computed columns cannot be used to query big tables.
This is the Table T1 which needs to be queried. The condition is any of the values in Col “Base” (VIDP or VABB) should be included in the Col “Search_ports” or “split_old_ports”. When i am creating the query, Row 2 of T1 is returned but Row 1 is not. I need that both these rows should be returned in the query.
Thanks got it. That would be difficult. For this functionality to work, the only workaround is add the same row multiple times with different values of base if the query uses AND logic or have more columns with different values of base while using a OR logic in query.
If I understood your case well, you need to create an array column based on your base column first and then, create a relation between this new column and your split_old_ports (array) column. In other words, you relation must use 2 arrays columns in order to find right values.