10 Replies Latest reply: Mar 9, 2017 9:41 AM by souad ouertani RSS

    Avoid joining

    souad ouertani

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