Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Auto join??

Hi,

If I have this 2 tables:

AB
a1b1
a2b2
a3b3
a4b4
a5b5
a6b6

AC
a1c1
a2c2

And I want a table that looks like:

AC
a1c1
a2c2


And I don't even do join, I just put everything from table 2 in a table, I end up with

AC
a1c1
a2

c2

a3-
a4-
a5-
a6-


What is the best way to get what I want?

I don't want to change the column name.

I am used to use LEFT JOIN ON etc. in mysql and now it seems like it automatic join if you have the same column names.

Thanks

1 Solution

Accepted Solutions

Auto join??

On the Dimensions tab, check "Suppress when value is null" for dimension "C" (or Order).

-Rob

http://robwunderlich.com

6 Replies

Re: Auto join??

Hi,

I suggest you load both the tables and after that create a pivot table on that for A field put condition

=If(A<='a2',A) to get data on for a1,a2 that is you want and see the attached for the solutions

Regards

Anand

Not applicable

Re: Auto join??

hi,

This is just an example. In the real situation A is a Customer and B is an Order. And not every Customer has an Order.

I want a table with all the Customers with an order.

Re: Auto join??

Hi,

So for this just add order dimention in chart also the data is filter according to your condition and display the Orders also.

Regards,

Anand

Not applicable

Re: Auto join??

Hi,

Thanks for your reply.

I will try it tomorrow morning.

Not applicable

Re: Auto join??

Use Right join not Left join

Auto join??

On the Dimensions tab, check "Suppress when value is null" for dimension "C" (or Order).

-Rob

http://robwunderlich.com

Community Browser