4 Replies Latest reply: Apr 28, 2014 11:03 AM by Josetxo Amonarriz RSS

    (The last I hope) table transformation

    Josetxo Amonarriz

      I would like to get Result table from tables A and B:

       

      Table A

      Header 1Header 2
      BS000022
      BS0000231
      BS010026

       

      Table B:

      Header 2Type
      22Head
      231Head
      26Head
      2200Posting
      2210Posting
      23100Posting
      23110Posting
      23120Posting
      2600Posting
      2650

      Posting

       

      Result table:

      Header 1Header 2
      BS00002200
      BS00002210
      BS000023100
      BS000023110
      BS000023120
      BS01002600
      BS01002650

       

      Many thanks in advance!