12 Replies Latest reply: Feb 20, 2014 6:25 AM by Massimo Grossi RSS

    Mapping question. Linking two tables

    Sergejs Kazakevics

      Hello,

       

      I've got to link two tables where the key field of the first table is the part of a key field of the second table.

      1. table

      KeyValue
      abcdisplayname1
      edfdisplayname2

      xyz

      displayname3

       

      2. table

      Key1
      abc123
      edf
      789xyz

       

      So I would like to link these two tables and get the result something like this:

      KeyKey1Value
      abcabc123displayname1
      edfedfdisplayname2
      xyz789xyzdisplayname3

       

      i found mapsubstring function but It seems will not work for this case. Have you got any advise about this?

       

      Thank you for you help in any case.

       

      ~Sergejs