topic Auto join?? in QlikView

Auto join??

Thu, 01 Sep 2011 13:54:51 GMT

Hi,

If I have this 2 tables:

A	C
a1	c1
a2	c2

And I want a table that looks like:

A	C
a1	c1
a2	c2

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

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

its_anandrjs — Thu, 01 Sep 2011 14:15:01 GMT

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

Thu, 01 Sep 2011 14:19:38 GMT

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.

its_anandrjs — Thu, 01 Sep 2011 14:26:16 GMT

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

Thu, 01 Sep 2011 14:29:24 GMT

Hi,

Thanks for your reply.

I will try it tomorrow morning.

Thu, 01 Sep 2011 16:16:31 GMT

Use Right join not Left join

rwunderlich — Thu, 01 Sep 2011 21:09:18 GMT

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

-Rob