topic Re: Combining independent tables in QlikView

Combining independent tables

nayanqlik — Wed, 25 Nov 2020 16:16:04 GMT

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

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

Re: Combining independent tables

MarcoWedel — Wed, 13 Jun 2018 21:43:47 GMT

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

Re: Combining independent tables

qlikviewwizard — Thu, 14 Jun 2018 02:20:43 GMT

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

];

Re: Combining independent tables

nayanqlik — Thu, 14 Jun 2018 04:21:59 GMT

Thank you Marco. It worked.

Kind regards

Nayan