Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello nice people,
I have a table that contains two fields (CDR/ departement). An réorganisation inside the company happened. Some departments are affected to a new CDR. My objective is to keep the former CDR if it doesn't change and get the new CDR with the corresponding department if it changes
//here's my script
NoConcatenate
Axe_CDR_Deparetemnt:
LOAD [Ancien CDR] as CDR,
[Intitulé Département] as Departement
FROM
[];
LOAD [Nouveaux CDR] as CDR,
[Intitulé Département] as Departement
FROM
[]
;
With my actual script, I get repetition the same department is affected to two CDR's
Any suggest on how to fix that?
Thanks a lot.
Map:
maping LOAD
[Intitulé Département] as Departement
[Nouveaux CDR] as CDR,
FROM
[]
;
//here's my script
NoConcatenate
Axe_CDR_Deparetemnt:
LOAD
//[Ancien CDR] as CDR,
applymap('Map',[Intitulé Département],[Ancien CDR]) as CDR,
[Intitulé Département] as Departement
FROM
[];
Hello,
I tried but I am getting cdr without name of departement..
here's my excel file
I want to get this as result :
put here the script wicth you use, please.
I already posted it.
NoConcatenate
Axe_CDR_Deparetemnt:
LOAD [Ancien CDR] as CDR,
[Intitulé Département] as Departement
FROM
[];
LOAD [Nouveaux CDR] as CDR,
[Intitulé Département] as Departement
FROM
[]
;
use This:
Map:
maping [Intitulé Département] as Departement
LOAD [Nouveaux CDR] as CDR,
FROM
[]
;
Axe_CDR_Deparetemnt:
LOAD
[Intitulé Département] as Departement,
applymap('Map',[Intitulé Département], [Ancien CDR]) as CDR
FROM
[];