topic Re: Joining MySQL tables from different sources in QlikView

Joining MySQL tables from different sources

Wed, 01 Apr 2015 19:30:59 GMT

I'm having issues joining tables from different databases. One table only exists on one database. When I attempt to join them through Qlikview I am getting null values in different rows. Here is a visual:

Unique_Key	Yes/No	Employee_1	Employee_2	Text_1	Text_2	Text_3	On/Off	Count
123456	Yes	-	Michael Jackson	Text	Text	Text	-	-
123456	-	James Brown	-	-	-	-	On	1
1234567	-	James Brown	-	-	-	-	Off	1
1234567	No	-	Michael Jackson	Text	Text	Text	-	-

The dashes represent null values. Is there a way to join SQL tables in Qlik where the end result is 1 row of values for each Unique_Key?

Re: Joining MySQL tables from different sources

Anonymous — Wed, 01 Apr 2015 19:53:03 GMT

It looks like a result of concatenate rather than join. Can you share the script or upload the app?

Re: Joining MySQL tables from different sources

Wed, 01 Apr 2015 20:03:36 GMT

Unfortunately no I can't upload the app.

Basically, "Employee_1" is the only info I need from the table cross databases. So Table_1 is grabbing the data, and Table_2 is also grabbing the data, resulting in multiple rows. As you can see though, the data exists in only 1 column, not both.

I was wondering if there was some sort of Qlik function where I could combine rows.

Re: Joining MySQL tables from different sources

Anonymous — Wed, 01 Apr 2015 20:11:42 GMT

But you can show the portions of the script, can't you? So far is not clear how exactly you're tying to join.

If you have Table1 with a Key and Field_A and Table2 with Key and Field_B, it should be

Table:

LOAD Key, Field_A;

SQL SELECT Key, Field_A FROM Table1;

JOIN (Table) LOAD Key, Field_B;

SQL SELECT Key, Field_B FROM Table2;