Hi All ,
I am getting a list of values from .CSV file from source.in that i want to compare two different field values. if that both values are repeat then third filed value count will add .
Example,
PO number =1,1,1,1,1
Material Number=a,b,a,a,c
quantity=1,1,1,1,1
Serial Number =aa,bb,cc,dd,ff
i am expecting
PO number =1, material number =a, Quantity=3,Serial Number =aa,bb,cc,
PO number=1 Material Number=b Quantity= 1,Serial Number =dd
PO number=1 Material Number=c Quantity= 1 , Serial Number =ff
Could you please help to complete this requirement.