Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to avoid this structure for column names
script:
Qualify *;
[DEPOTCOMPTEF]:
LOAD
'COMPTES' AS PRODUIT,
ANNEE & '-' & IF(MOIS ='janv.','01',IF(MOIS='févr.','02',IF(MOIS='mars','03',IF(MOIS='avr.','04',IF(MOIS='mai','05',IF(MOIS='juin','06',IF(MOIS='juil.','07',IF(MOIS='août','08',IF(MOIS='sept.','09',IF(MOIS='oct.','10',IF(MOIS='nov.','11','12'))))))))))) AS SITUATIONDEPOTCOMPTE,
STAUT_CLIENT AS STATUT_CLIENT,
MARCHE,
DESCRIPTION_MARCHE_CLIENT,
%ID_AGENCE_CTOS_COMPTE,
%ID_AGENCE_CTOS_COMPTE AS AGENCEDEPOTCOMPTE,
AGE_RELATION,
DESCRIPTION_CATEGORIE_CLIENT,
%ID_CATEGORIE_CLIENT,
%ID_DEVISE_COMPTE ,
NATURE_COMPTE ,
DESCRIPTION_TYPE_DEPOT_COMPTE ,
DESCRIPTION_SOUS_TYPE_DEPOT_COMPTE ,
%ID_TYPE_DEPOT_COMPTE ,
%ID_SOUS_TYPE_DEPOT_COMPTE ,
PROD_COMPTE ,
STATUT_COMPTE ,
SEGMENT,
0 AS ATTRITION,
CONQUETE,
ANCIENNETE_RELATION,
VENTE_COMPTE ,
STOCK_COMPTE ,
SOUS_MARCHE,
TYPE_SOUS_MARCHE,
SEGMENT_2015 as SEGMENT_N_1
From
C:\pfe\DONNEES_RECAP\DEPOTS_COMPTE.qvd
(qvd);
Qualify *;
[DEPOTCOMPTE]:
LOAD *,
RowNo() as tDEPOTCOMPTE_id
Resident [DEPOTCOMPTEF];
DROP Table DEPOTCOMPTEF;
yes marcus because i have a linktable, with rowno at the first load doesnt work
yes marcus because i have a linktable, with rowno at the first load doesnt work, but With Aar's solution, it works correctly
I do not want to display the column name with a long hierarchy but i found the solution now it works correctly
Qualify *;
[PACKF]:
LOAD
'PACKS' AS PRODUIT,
%ID_AGENCE_CTOS_PACK,
ANNEE & '-' & IF(MOIS ='janv.','01',IF(MOIS='févr.','02',IF(MOIS='mars','03',IF(MOIS='avr.','04',IF(MOIS='mai','05',IF(MOIS='juin','06',IF(MOIS='juil.','07',IF(MOIS='août','08',IF(MOIS='sept.','09',IF(MOIS='oct.','10',IF(MOIS='nov.','11','12'))))))))))) AS SITUATIONPACK,
STAUT_CLIENT AS STATUT_CLIENT,
MARCHE,
DESCRIPTION_MARCHE_CLIENT,
%ID_AGENCE_CTOS_PACK AS AGENCEPACK,
AGE_RELATION,
DESCRIPTION_CATEGORIE_CLIENT,
%ID_CATEGORIE_CLIENT,
%ID_TYPE_PACK ,
LIB_TYPE_PACK ,
SEGMENT,
'PACK' AS TYPE,
CONQUETE,
ANCIENNETE_RELATION,
NOMBRE_PACK ,
0 AS PROD_MOIS,
STATUT_PACK AS STATUT_PROD,
'PACK' AS NATURE,
SOUS_MARCHE,
TYPE_SOUS_MARCHE,
SEGMENT_2015 as SEGMENT_N_1
FROM
(qvd);
Qualify *;
[PACKS]:
LOAD *,
RowNo() as tPACK_id
Resident [PACKF];
DROP Table PACKF;
Awesome