2 Replies Latest reply: May 27, 2014 4:46 AM by Bert Holtjer RSS

    Concatenate, or Join, or ?

      Cracking my head on the following...

       

      I have two tables

       

      Table1 has every row only one case.

      Table2 can have multiple row from the same case (max. 3 times)

       

      qv1.png

       

      I want to merge both tables, but with ALL the collums, and additional colloms (form the other table, but with prefixes (max till 3) , like this:

       

      qv2.png

      Starting to get desired data using IF statements, but then the load starting to get VERY long... already with my test data, this wil lbe unworkable with the real data

       

      Hope you understand my point, and even more hope that you have the solution (: