4 Replies Latest reply: Feb 20, 2010 4:10 PM by QuestionsQuestions RSS

    Bringing fields from 2 tables together into 1

      Right, an easy one here i'm sure :)

      I have data regarding the same records, held in 2 separate tables:

      e.g.

      Table1:

      ID, A, B, C

      Table 2:

      ID, D, E

      i want to bring them togther in my script to give me one table in qlikview, because there really is no reason for the data to be apart

      so i want to create

      Table 3:

      ID, A, B, C, D. E

      and drop Tables 1 & 2

      Can someone tell me how to do this?

      Thanks in advance

      Matt