Skip to Content
0
May 27, 2018 at 08:10 AM

compare two values if values is repeated count thard value

67 Views

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.