topic Re: Redundancy in Data in QlikView

Redundancy in Data

master_student — Tue, 19 Jul 2016 14:11:18 GMT

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.

Re: Redundancy in Data

Tue, 19 Jul 2016 14:17:04 GMT

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

[];

Re: Redundancy in Data

master_student — Wed, 20 Jul 2016 09:37:31 GMT

Hello,

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

here's my excel file

I want to get this as result :

Re: Redundancy in Data

Wed, 20 Jul 2016 12:13:50 GMT

put here the script wicth you use, please.

Re: Redundancy in Data

master_student — Wed, 20 Jul 2016 12:27:34 GMT

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

[]

;

Re: Redundancy in Data

Wed, 20 Jul 2016 12:34:35 GMT

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

[];