4 Replies Latest reply: Mar 22, 2013 3:17 AM by Robin Tappij Gielen RSS

    How to show a match of two tabels?

    Robin Tappij Gielen

      Hi,

       

      I'll have two different tabels where I want to find and show a match in one of them.

      I'll only want to use an expression.

       

      Example:

       

      Tabel 1:

       

       

      Header 1Header 2
      1aaa
      2cac
      3bbb
      4ddd
      5ccc
      6aba

       

      Tabel 2:

      Header 1Header 2Header 3
      1fffno match
      2cacmatch
      3aaamatch
      4abamatch
      5gggno match
      6cccmatch

       

      Header 2 of tabel 1 looks into tabel 2 (Header 2) to find a match.

       

      What is the expression for Header 3 to solve this?

       

      Gr. Tappij