Find partial (but closes) matches for terms in 2 differents tables

Would it be possible to use Baserow to find partial (but closes) matches for terms in 2 differents tables (specific cells) and show the associated lines data?
Ex.

In table 1, in the choosen column for this query, there is a cell with ‘behind the word mountains’
In table 2, in the choosen column there is a cell with ‘behind words mountains’

I would like to output both cells thats match, along all data on the same line for both tables.

Hey there :slight_smile:

This could be achieved by using Link row and lookup fields.

To also search data from another table you would need to add that data to your current table by first making a link row field connected to that table and then you could add a lookup field for every relevant field you want to have “duplicated” in your current table from the other table.

Just being able to run search and it will automatically search multiple tables and merge the results, is not something you can just do by enabling a setting for example.

Hope that helps :slight_smile: