5 Replies Latest reply: Jan 29, 2018 12:31 PM by Michael Gray RSS

    How to create row for each record combination in two tables?

    Michael Gray

      I have two tables.  One is a list of dealers.  The other is a list of products.  I want to create one table that has a row for each dealer and each product.   What is the best way to do this in Qlik Sense?

       

      Table 1 (dealer)

      A

      B

      C


      Table 2 (products)

      1

      2

      3

       

      Result table

      A     1

      A     2

      A     3

      B     1

      B     2

      B     3

      C     1

      C     2

      C     3

       

      Thanks in advance!