Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

http://robwunderlich.com

View solution in original post

6 Replies
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

Not applicable
Author

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

Not applicable
Author

Hi,

Thanks for your reply.

I will try it tomorrow morning.

Not applicable
Author

Use Right join not Left join

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

http://robwunderlich.com