5 Replies Latest reply: Apr 25, 2014 11:35 AM by Josetxo Amonarriz RSS

    (Another) Table transformation

    Josetxo Amonarriz

      Hello Community!

       

      I have two tables that I would like to join in a third table:

       

      Table A

      Header 1Header 2
      BS000022
      BS000023
      BS010026

       

      Table B

      Header 2Type
      22Head
      2200Posting
      2210Posting
      23Head
      2300Posting
      2310Posting
      2320Posting
      26Head
      2600Posting
      2650

      Posting

       

      Result table:

      Header 1Header 2
      BS00002200
      BS00002210
      BS00002300
      BS00002310
      BS00002320
      BS01002600
      BS01002650

       

      The link are the values under "Header 2" in TableA, but they do not have to appear in result table.

      The values under 22, 23 and 26 with "Posting" are the ones to appear.

       

      Any help will be highly appreciated! Many thanks in advance.