topic Problem with join in QlikView

Problem with join

Fri, 07 Apr 2017 11:17:36 GMT

hello,

i have a problem with qlikview

i have two tables:

table1:

LOAD [ téléphone],

[Nom ],

[Période d],

Month("Période ") as mois,

Year("Période ") as année,

[Montant ],

[ rubrique],

[ sous-rubrique],

[ rubrique de niveau 1],

[ rubrique de niveau 2]

resident Facture;

table2:

outer join Load [Catégorie],[Sous catégorie],[rubrique],

[ sous-rubrique],

[ rubrique de niveau 1],

[ rubrique de niveau 2] resident Catégories ;

Drop table Facture;

Drop table Catégories;

Facture and catégorie was declared before

i want to have the result like this:

Numéro	Nom	Mois	Année	Montant	rubrique	sous rubrique	rubrique niveau 1	rubrique niveau 2	catégorie	sous catégorie

i want to know if my reflexion aboutit is right?

thanks

Re: Problem with join

rahulpawarb — Mon, 10 Apr 2017 07:48:54 GMT

Hello Anis,

If you want to join a Table1 with Table2 then you should have a common field between both the tables (with same name - case sensitive). You can make the necessary changes in your script accordingly.

Hope this will help.

Regards!

Rahul

Re: Problem with join

avinashelite — Mon, 10 Apr 2017 07:53:06 GMT

Which tables your join ?

You need at least one common key between the tables otherwise it will lead to the cross join ...

Re: Problem with join

Mon, 10 Apr 2017 08:53:39 GMT

Thanks for the answer, but i have 4 common fields which are: rubrique, sous-rubrique, rubrique-niveau-1, rubrique-niveau-2 with the same names

Re: Problem with join

rahulpawarb — Mon, 10 Apr 2017 10:10:09 GMT

Hello Anis,

If you have four common fields as stated above in both the tables and to relate data from one table with another you need four of them then you can create a complex key by concatenating these four fields in both the tables; post that remove/rename/qualify these four fields from one of the table(refer below sample key):

rubrique & '|' & sous-rubrique & '|' & rubrique-niveau-1 & '|' & rubrique-niveau-2 AS Key

Hope this will be helpful.

Regards!

Rahul

Re: Problem with join

avinashelite — Mon, 10 Apr 2017 10:22:45 GMT

I feel the problem is with the data you have , could please share the sample data set and the app

Re: Problem with join

Mon, 10 Apr 2017 10:25:11 GMT

the problem is not with the data, because i use them for other treatment and it works good. iwill try the composite key perhaps it's the solution.

Thanks