Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nayanqlik
Partner - Creator
Partner - Creator

Combining independent tables

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

 

CustomerMonth
AJan-18
AFeb-18
BMar-18
BJan-18
CFeb-18
CMar-18

 

Product
1
2

3

Customer

Month

Product
AJan-181
AFeb-181
BMar-181
BJan-181
CFeb-181
CMar-181
AJan-182
AFeb-182
BMar-182
BJan-182
CFeb-182
CMar-182
AJan-183
AFeb-183
BMar-183
BJan-183
CFeb-183
CMar-183

 

1 Solution

Accepted Solutions
MarcoWedel

Hi,

one solution might be:

QlikCommunity_Thread_304798_Pic1.JPG

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

View solution in original post

3 Replies
MarcoWedel

Hi,

one solution might be:

QlikCommunity_Thread_304798_Pic1.JPG

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
Master II
Master II

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

];

1.PNGCapture.PNG

nayanqlik
Partner - Creator
Partner - Creator
Author

Thank you Marco.  It worked.

Kind regards

Nayan