awk script to find duplicate values

Shell Programming and Scripting
1

The data below consits of items with Class, Sub Class and Property values. I would like to find out same value being captured for different property values for a same Class/Sub Class combination (with in an Item & across items). Like 123 being captured for PAD1, PAD2, PAD4 for ABC-DEF, 456 captured for PXM1, PXM4 and 234 captured for PAD2, PAD1. (Note sometime value could be separated by coma(,) within a cell)

Column Separator = Pipe (|)

Input data

ID|Class|SubClass|Prop|Value
1|ABC|DEF|PAD1|123|
1|ABC|DEF|PAD2|234|
1|ABC|DEF|PAD3|476|
1|ABC|DEF|PAD4|123|
2|XYZ|MNF|PXM1|456|
2|XYZ|MNF|PXM2|289|
2|XYZ|MNF|PXM3|279|
2|XYZ|MNF|PXM4|488,456|
2|XYZ|MNF|PXM5|284|
3|ABC|DEF|PAD1|234|
3|ABC|DEF|PAD2|777,123|
3|ABC|DEF|PAD3|567|
3|ABC|DEF|PAD4|556|

Output data

ID|Class|SubClass|Prop|Value|
1|ABC|DEF|PAD1|123|
1|ABC|DEF|PAD4|123|
3|ABC|DEF|PAD2|123|
3|ABC|DEF|PAD1|234|
1|ABC|DEF|PAD2|234|
2|XYZ|MNF|PXM1|456|
2|XYZ|MNF|PXM4|456|

Thanks

2 
awk -F'|' 'NR==FNR {split($5,a,","); for(i in a) {A[a]++; $5=a; print $0 >> "file.tmp"}} NR!=FNR && (FNR==1 || A[$5]>1)' OFS='|' file file.tmp && rm file.tmp
3

Try also

awk     'NR==1  {print; next}
         function Z (P) {X=$2","$3","P; T[X]=T[X] D[X] sprintf ("%s|%s|%s|%s|%s|", $1, $2, $3, $4, P); C[X]++; D[X]="\n"}
                {Z ($5)}
         NF>6   {Z ($6)}
         END    {for (i in T) if (C>1) print T}
        ' FS="[,|]" file
ID|Class|SubClass|Prop|Value
2|XYZ|MNF|PXM1|456|
2|XYZ|MNF|PXM4|456|
1|ABC|DEF|PAD1|123|
1|ABC|DEF|PAD4|123|
3|ABC|DEF|PAD2|123|
1|ABC|DEF|PAD2|234|
3|ABC|DEF|PAD1|234|
4

Thanks RudiC, its working as expected. But I am struggling a bit to convert into a script file. Can you please help me.

Thanks

5

... if you tell me what you are struggling with ... my crystal ball needs some polishing, you know.