Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
thx