topic Re: Isolate Duplicate Key Field in QlikView

Isolate Duplicate Key Field

Tue, 30 Sep 2014 19:43:45 GMT

I need to create a resident table in my data model that contains all the rows in Temp2 that contain a duplicated LoadNumber. In this example, 1237, 100 ; 1237, 150.0 ; 1241, 75 ; 1241, 100.0 ; 1241, 125 ; 1241, 250. I have tried a variety of joins and experimented with EXISTS, but I'm not obtaining the table I need. Any suggestions will be greatly appreciated!

Temp2:

LOAD * INLINE [

LoadNumber, ManifestClass

1234, 50

1235, 100

1236, 75.0

1237, 100

1237, 150.0

1240, 250

1241, 75

1241, 100.0

1241, 125

1241, 250

];

Thanks,

Steve

Re: Isolate Duplicate Key Field

maxgro — Tue, 30 Sep 2014 20:17:31 GMT

Temp2:

LOAD * INLINE [

LoadNumber, ManifestClass

1234, 50

1235, 100

1236, 75.0

1237, 100

1237, 150.0

1240, 250

1241, 75

1241, 100.0

1241, 125

1241, 250

];

left join (Temp2)

load LoadNumber,

if(count(LoadNumber)>1, 'DUPLICATE', 'OK') as flag

Resident

Temp2

group by LoadNumber;

Re: Isolate Duplicate Key Field

Wed, 01 Oct 2014 12:33:37 GMT

Massimo,

That is excellent!

Thank you,

Steve