topic Re: Avoid joining in QlikView

Avoid joining

souadouert — Thu, 09 Mar 2017 13:54:13 GMT

I have several tables with columns with the same name but not with the same value, so the qlik will bind these columns together, here is the example so I'm looking for a solution to avoid these joiuntre

LOAD MOIS,

ANNEE,

STAUT_CLIENT,

MARCHE,

DESCRIPTION_MARCHE_CLIENT,

AGE_RELATION,

DESCRIPTION_CATEGORIE_CLIENT,

%ID_CATEGORIE_CLIENT,

SEGMENT,

CONQUETE,

ANCIENNETE_RELATION,

STATUT_AVA,

PROD_AVA,

%ID_AGENCE_CTOS_CLIENT,

SOUS_MARCHE,

SEGMENT_2015,

TYPE_SOUS_MARCHE,

NOMBRE_AVA

FROM

C:\pfe\DONNEES_RECAP\AVA.qvd

(qvd);

LOAD MOIS,

ANNEE,

STAUT_CLIENT,

MARCHE,

DESCRIPTION_MARCHE_CLIENT,

%ID_AGENCE_CTOS_CLIENT,

AGE_RELATION,

DESCRIPTION_CATEGORIE_CLIENT,

%ID_CATEGORIE_CLIENT,

SEGMENT,

CONQUETE,

ANCIENNETE_RELATION,

SOUS_MARCHE,

TYPE_SOUS_MARCHE,

SEGMENT_2015,

PROD_BENOUN,

STATUT_BENOUN,

NOMBRE_BENOUN

FROM

C:\pfe\DONNEES_RECAP\BENOUN.qvd

(qvd);

LOAD MOIS,

ANNEE,

STAUT_CLIENT,

MARCHE,

DESCRIPTION_MARCHE_CLIENT,

%ID_AGENCE_CTOS_CLIENT,

AGE_RELATION,

DESCRIPTION_CATEGORIE_CLIENT,

%ID_CATEGORIE_CLIENT,

PROD_BN,

STATUT_BN,

SEGMENT,

CONQUETE,

ANCIENNETE_RELATION,

SOUS_MARCHE,

SEGMENT_2015,

TYPE_SOUS_MARCHE,

NOMBRE_BIATNET

FROM

C:\pfe\DONNEES_RECAP\BIATNET.qvd

(qvd);

Re: Avoid joining

ahaahaaha — Thu, 09 Mar 2017 14:01:30 GMT

Hi,

Use NoConcatenate. Plus it's better to give your names to tables.

Regards,

Andrey

Re: Avoid joining

souadouert — Thu, 09 Mar 2017 14:09:50 GMT

i put NoConcatenate between these two tables ?? with this option i have the table synt

Re: Avoid joining

ahaahaaha — Thu, 09 Mar 2017 14:15:26 GMT

At the end of the script, in any case, Qlik will link fields of same name. NoConcatenate allows tables to be downloaded separately, and not into one. To prevent the tables from being associated, the fields will have to be renamed.

Re: Avoid joining

souadouert — Thu, 09 Mar 2017 14:16:37 GMT

is the only solution ??

Re: Avoid joining

ahaahaaha — Thu, 09 Mar 2017 14:20:09 GMT

I do not know your task. Perhaps the solution would be to load all the tables into one with the addition of a field containing the attribute of the source table.

Re: Avoid joining

avinashelite — Thu, 09 Mar 2017 14:20:26 GMT

You could use the Qualifier * ; Key word it will qualify all the tables and use

unQualify field names ; to link the fields which are required

Re: Avoid joining

avinashelite — Thu, 09 Mar 2017 14:21:43 GMT

check this doc

Do you Qualify?- How to use QUALIFY statement

how to use Qualify

Re: Avoid joining

benjamins — Thu, 09 Mar 2017 14:22:44 GMT

Try putting

QUALIFY *;

above your LOAD statements and see if that is the result you are looking for.

Re: Avoid joining

souadouert — Thu, 09 Mar 2017 14:41:08 GMT

thx

Re: Avoid joining

souadouert — Thu, 09 Mar 2017 14:41:18 GMT

thx