Remove duplicates.

arvind.m · Posted: Wed Sep 02, 2009 4:28 pm

arvind.m · Posted: Wed Sep 02, 2009 4:34 pm

In the above example, item 0111315 and upc 00007362100243 have duplicate combination of state,supp,item and upc. so the output should be just

gcicchet · Posted: Wed Sep 02, 2009 4:43 pm

Hi,

try

arvind.m · Posted: Wed Sep 02, 2009 4:49 pm

Hi Gerry,

where do i need to add the sort card (i mean in which step).

arvind.m · Posted: Wed Sep 02, 2009 4:52 pm

Hi Gerry,

i used the sort card which you mentioned in the second step. but it did not work.

gcicchet · Posted: Wed Sep 02, 2009 4:54 pm

Hi Arvind,

the line I gave you belongs to the second step.

The first step has additional sort fields.

Gerry

gcicchet · Posted: Wed Sep 02, 2009 4:57 pm

Hi,

what does the output from step1 look like ?

Gerry

arvind.m · Posted: Wed Sep 02, 2009 5:01 pm

Gerry,

My first step will sort the input file and will make sure that the record with status "CURR" is on the top. (not taking qty into consideration)

and the second step will remove the duplicate records. Since the reocrds with status "CURR" are on the top they are not eliminated.

let me know if this makes any sense.

gcicchet · Posted: Wed Sep 02, 2009 5:07 pm

Hi Arvind,

I have run the JCL without the parameter XSUM as it is not supported with the version of DFSORT I'm using and the results are correct.

What does the file from the first step look like ?

Gerry

arvind.m · Posted: Wed Sep 02, 2009 5:25 pm

the above input file has only few records to test it.

new input to first step

arvind.m · Posted: Wed Sep 02, 2009 5:27 pm

sorry....

output from first step

gcicchet · Posted: Wed Sep 02, 2009 5:43 pm

Hi Armand,

this is getting very confusing.

How do the last 2 records go from 00004 PREV to 00004 CURR and 00006 CURR to 00006 PREV ?

I would use the following in step1

arvind.m · Posted: Wed Sep 02, 2009 5:49 pm

sorry Gerry...there was a typo...

correct output is

gcicchet · Posted: Wed Sep 02, 2009 5:56 pm

Hi Arvind,

I think you are wrong again, the output from your first step is as below

arvind.m · Posted: Wed Sep 02, 2009 6:15 pm

No Gerry,
in the first sort card "qty" is not considered (5th field) while sorting.....

gcicchet · Posted: Wed Sep 02, 2009 6:27 pm

Hi Arvind,

I didn't realize you had changed the sort card in step1, now that we agree on the first sort card, are you still having problems when using the 2nd sort card I provided.

Gerry