Grouping Data with same matching data in a grouped section

General
Enthusiast

Grouping Data with same matching data in a grouped section

I have a situation not sure if i am putting it right way, I have a grouped data as below 







EFF_ID CMD1 CMD2 PBProfileNm ProfName
absprod ksh ANY pbentpcl aladdin
absprod ksh ANY pbentpcl arpine
absprod ksh ANY pbentpcl sd2n3v6
absprod ksh ANY pbepcunx aladdin
absprod ksh ANY pbepcunx arpine
absprod ksh ANY pbepcunx jeor
absprod ksh ANY pbepcunx mkd21qn
absprod ksh ANY pbepcunx quint2
absprod ksh ANY pbepcunx sd2n3v6
absprod ksh ANY pbepcunx varys

The last column "ProfName" has same data compared by grouping of 1st to 4th columns as




aladdin                             
arpine                              
sd2n3v6                             

I am looking for final results as create a incrimental group data set value 










absprod ksh ANY (blank) (blank) pbentpcl aladdin
            arpine
            sd2n3v6
          pbepcunx aladdin
            arpine
            sd2n3v6
absprod_1 ksh ANY (blank) (blank) pbepcunx jeor
            mkd21qn
            quint2
            varys

The PBProfileNm column having value pbentpcl, pbepcunx has same data :  aladdin, arpine, sd2n3v6

they are grouped into one set the next set of data which does not match need to be seperated out.

1 REPLY
Enthusiast

Re: Grouping Data with same matching data in a grouped section

My original post data is unformatted coping again with correct format.

Data

EFF_ID        CMD1     CMD2     PBProfileNm   ProfName

absprod        ksh        ANY        pbentpcl          aladdin

absprod        ksh        ANY        pbentpcl          arpine

absprod        ksh        ANY        pbentpcl          sd2n3v6

absprod        ksh        ANY        pbepcunx        aladdin

absprod        ksh        ANY        pbepcunx        arpine

absprod        ksh        ANY        pbepcunx        jeor

absprod        ksh        ANY        pbepcunx        mkd21qn

absprod        ksh        ANY        pbepcunx        quint2

absprod        ksh        ANY        pbepcunx        sd2n3v6

absprod        ksh        ANY        pbepcunx        varys

Result : creating incremental EFF_ID "_1" as seperate group set.

EFF_ID       CMD1       CMD2      PBProfileNm    ProfName

absprod       ksh       ANY       pbentpcl       aladdin

absprod       ksh       ANY       pbentpcl       arpine

absprod       ksh       ANY       pbentpcl       sd2n3v6

absprod       ksh       ANY       pbepcunx       aladdin

absprod       ksh       ANY       pbepcunx       arpine

absprod       ksh       ANY       pbepcunx       sd2n3v6

absprod_1       ksh       ANY       pbepcunx       jeor

absprod_1       ksh       ANY       pbepcunx       mkd21qn

absprod_1       ksh       ANY       pbepcunx       quint2

absprod_1       ksh       ANY       pbepcunx       varys