Redundancy in Data

[master_student]

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.

[#2]

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

[];

[master_student]

Hello,

I tried but I am getting cdr without name of departement..

here's my excel file

I want to get this as result :

[#4]

put here the script wicth you use, please.

[master_student]

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

[]

;

[#6]

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

[];