9 Replies Latest reply: Jan 22, 2017 6:53 AM by Stefan Wühl RSS

    Compare text strings from 2 different tables and return value from table 2

    Anat Dagan

      Hi,

      I have 2 tables with texts strings and i am trying to compare / find matches between the 2 in order to retrieve additional data that relates to one of them.

       

      Table1 has 2 columns: id, TitleKeyword

      Each ID has more than one TitleKeyword entry.

       

      Table2 includes 2 columns: Keywords, EtsySearchResults.

       

      I want to build a simple table that includes the 2 columns from table 1 + a third column that returns EtsySearchResults value whenever TItleKeyword=Keywords.

       

      I tried using this IF statement:

       

      If(TitleKeyword=keywords,Sum(EtsySearchResults),'No Data')

       

      But oddly it only returns a value if I filter on the Keyword term.

       

      For example, if i filter on  Keyword black tote bag on table 2, i get the search results on table 1 (see below):

       

       

      If i release the filter, the third column in table 1 says "No Data" (see below)

       

      Why is that?

      How do I get the EtsySearchResults to show against each TitleKeyword that has an equivalent keyword on table 2?