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: 
souadouert
Specialist
Specialist

Avoid joining

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);

1 Solution
10 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi,

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

Regards,

Andrey

souadouert
Specialist
Specialist
Author

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

ahaahaaha
Partner - Master
Partner - Master

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.

souadouert
Specialist
Specialist
Author

is the only solution ??

ahaahaaha
Partner - Master
Partner - Master

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.

avinashelite

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

benjamins
Partner - Creator
Partner - Creator

Try putting

QUALIFY *;

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

souadouert
Specialist
Specialist
Author

thx