Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
nayanqlik
New Contributor III

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

Re: Combining independent tables

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

3 Replies

Re: Combining independent tables

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

Arjunarao
Honored Contributor II

Re: Combining independent tables

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
New Contributor III

Re: Combining independent tables

Thank you Marco.  It worked.

Kind regards

Nayan

Community Browser