Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter columns on two different tables

Hello,

 

I'm trying to filter two columns from two different tables.  

 

I tried doing a conditional column where if Description column Contains "Traditional" then "Yes"
or
if Quotes column Contains "Traditional" then "Yes"

Else
"No"


Since the columns are on different tables, it's not working correctly.

 

Any ideas are greatly appreciated!

 

Need Help
  • speedramps's avatar
    speedramps
    4 years ago

    Please consider this solution and leave Kudos.

     

    Merge the tables using a common key and select the missing field, so you have all the required fields in one table.

     

    You can then filter the rows using the 2 columns.

2 Replies

  • speedramps's avatar
    speedramps
    Icon for Super User rankSuper User
    4 years ago

    Please consider this solution and leave Kudos.

     

    Merge the tables using a common key and select the missing field, so you have all the required fields in one table.

     

    You can then filter the rows using the 2 columns.