Auto join??

[#1]

Hi,

If I have this 2 tables:

A	B
a1	b1
a2	b2
a3	b3
a4	b4
a5	b5
a6	b6

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

A	C
a1	c1
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

[its_anandrjs]

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

[#3]

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]

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

[#5]

Hi,

Thanks for your reply.

I will try it tomorrow morning.

[#6]

Use Right join not Left join

[rwunderlich · Accepted solution]

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

-Rob

http://robwunderlich.com