topic Joining 2 tables in Connectivity & Data Prep

Joining 2 tables

MALKITOM — Fri, 10 Dec 2021 20:23:41 GMT

Hello,

First of all I would like to say 'Hello' as I am new to this forum.

I have started my journey with QlikSense few weeks ago and I have resolved some issues on my own. However, going though different websites, forums etc. even if I have found answer on my question (below), solution has not been working correctly for me. Could I ask for your support?

Let's assume that I have 2 tables:

Table1:

Table1.ID

Table1.Name

Table1.Surname

Table1.XXX

Table2:

Table2.ID

Table2.Description

Table2.Salary

As an output I would like to have following table:

FinalTable:

FinalTable.ID

FinalTable.Name

FinalTable.Surname

FinalTable.Description

FinalTable.Salary

Table1.ID and Table2.ID is field by which table should be connected (joined). It does not matter what kind of data tables contain, it just a matter to getting final outcome.

I would appreciate for any suggestion, help.

Regards,
Tom

Re: Joining 2 tables

Taoufiq_Zarra — Tue, 23 Feb 2021 10:04:39 GMT

@MALKITOM like ?

FinalTable: load Table1.ID,Table1.Name,Table1.Surname,Table1.XXX SQL SELECT * ....; left join // or join or right join load Table2.ID as Table1.ID,Table2.Description,Table2.Salary SQL SELECT * ....;

Re: Joining 2 tables

MALKITOM — Wed, 24 Feb 2021 08:53:32 GMT

It does not work for me 😞

I have made as follows:

FinalTable:

Load

Table1.ID As FinalTable.ID,
Table1.Name As FinalTable.Name,
Table1.Surname As FinalTable.Surname

RESIDENT [Table1];

SQL SELECT * FROM [Table1];

LOAD

Table1.ID AS Table2.ID,
Table2.Description As FinalTable.Description,
Table2.Salary As FinalTable.Salary,

RESIDENT [Table2];

SQL SELECT * FROM [Table2];

It states that 'There is no open data connection.'

Regards,
Tom

Re: Joining 2 tables

Taoufiq_Zarra — Wed, 24 Feb 2021 09:03:00 GMT

@MALKITOM

FinalTable: Load ID As FinalTableID, Name As FinalTableName, Surname As FinalTableSurname ; SQL SELECT * FROM [Table1]; left join // you can change it to right join or join LOAD ID As FinalTableID, Description As FinalTableDescription, Salary As FinalTableSalary, ; SQL SELECT * FROM [Table2];

I guess the database fields are called: ID,Name,Surname from table 1 and ID,... from table 2 !

Re: Joining 2 tables

MALKITOM — Wed, 24 Feb 2021 11:47:23 GMT

Hi,

Still when loading data from script I got: 'There is no open data connection'.

Regards,
Tom

Re: Joining 2 tables

Taoufiq_Zarra — Wed, 24 Feb 2021 12:06:22 GMT

@MALKITOM do you have SQL connexion or ou load data from file ?

Re: Joining 2 tables

MALKITOM — Wed, 24 Feb 2021 12:19:13 GMT

@Taoufiq_Zarra please find below steps that I am performing (issue described below is just part of my script code)

Load data from file. Let's call it Table A.
Split Table A to Table B, Table C, Table D (with Load statement, resident of Table A, with where conditions)
Table B contains data that I am interested in (OK)
Table C contains some data and Table D contains rest of data (those 2 tables need to be merged / joined by column field called ID - exists in both tables, some columns need to be taken from Table C, some from Table D) - this is issue described above.

Due to security policy reason, I am not able to provide you any code sample and so on. I do my best to describe issue as much as I can.

Regards,

Tom