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);
Hi,
Use NoConcatenate. Plus it's better to give your names to tables.
Regards,
Andrey
i put NoConcatenate between these two tables ?? with this option i have the table synt
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.
is the only solution ??
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.
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
Try putting
QUALIFY *;
above your LOAD statements and see if that is the result you are looking for.
thx