Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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