16 Replies Latest reply: Apr 23, 2016 10:54 AM by Maarten Borsten Branched from an earlier discussion. RSS

    Join or Keep? Multiple records in table 2 should result in 1 row

    Maarten Borsten

      If the Key in Table 1 = 1,2,3

      and I have a Key in Table 2 that is 1,2,3

       

      But in Table 1 each key appears only once and in Table 2 it appears around three times per record. I want only the table 1 enriched with table 2 data and not more data lines created than table 1 initially had.

       

      If that is what you wanted to know aswell... Any thoughts on this yet?