2 Replies Latest reply: Dec 7, 2009 4:40 PM by Håkan Johansson RSS

    Cartesian product in QV

    Håkan Johansson

      Hi,

      I would like to create the cartesian product by joining two tables. Table1 is read into QV from a database and the other is generated internally within QV. An example of what I would like to do is:

      Table1

      Field1 Field2 Field3

      1 A 22

      2 B 71

      Table2

      Field2

      A

      B

      C

      The "join" should result in the following table

      Field1 Field2 Field3

      1 A 22

      1 B -

      1 C -

      2 A -

      2 B 71

      2 C -

       

      Any suggestions on how this can be done?

      Thanks,

      /HJ