Combining independent tables

[nayanqlik]

Hi

I have 2 independent tables below.  One is Customer per Month.  The other table is product.  I want to create a new table to show Customer per Month per Product (3rd table below is the result i want). 

How do i do this.  Your help is appreciated.

Kind regards

Nayan

Customer	Month
A	Jan-18
A	Feb-18
B	Mar-18
B	Jan-18
C	Feb-18
C	Mar-18

Product

1

2

3

Customer	Month	Product
A	Jan-18	1
A	Feb-18	1
B	Mar-18	1
B	Jan-18	1
C	Feb-18	1
C	Mar-18	1
A	Jan-18	2
A	Feb-18	2
B	Mar-18	2
B	Jan-18	2
C	Feb-18	2
C	Mar-18	2
A	Jan-18	3
A	Feb-18	3
B	Mar-18	3
B	Jan-18	3
C	Feb-18	3
C	Mar-18	3

[MarcoWedel · Accepted solution]

Hi,

one solution might be:

tabResult:
LOAD Customer, 
     Month
FROM [https://community.qlik.com/thread/304798] (html, codepage is 1252, embedded labels, table is @1);

Join

LOAD Product
FROM [https://community.qlik.com/thread/304798] (html, codepage is 1252, embedded labels, table is @2);

hope this helps

regards

Marco

[qlikviewwizard]

Hi,

Check my solution.

CUSTOMER:

LOAD * INLINE

[Customer,Month

A,Jan-18

A,Feb-18

B,Mar-18

B,Jan-18

C,Feb-18

C,Mar-18

];

OUTER JOIN (CUSTOMER)

PRODUCT:

LOAD * INLINE

[

Product

1

2

3

];

[nayanqlik]

Thank you Marco.  It worked.

Kind regards

Nayan