How to Display two values from different tables in one row of a third table?

1

So this is basically, what i need to achive:

  1. I paste the Tags into column 2 of “Text 1” and “Text 2”
  2. The system needs to find matching text
  3. and displays the values of column “Name” in the same row in “Table”

SCR-20231028-nakf-3
SCR-20231028-nakf-31226×1702 155 KB

Anybody an idea?

Thx

2

Hi !

I tried to copy your tables and for me it works like this. But the thing that is unclear to me is that you have multiple tags in your Table Text 1 but you want only one to appear in your Matching tag column. How do you decide which one ?

Tell me if this helps :slight_smile:

1 Like
3

Hi Aurelie :slight_smile: , thanks for the answer.

The system needs to show all matching combinations once.

So whenever Text 1 and Text 2 have one or multiple matches, the combination of Text 1 & Text 2 should be shown once.