cancel
Showing results for 
Search instead for 
Did you mean: 

compare two values if values is repeated count thard value

surya6244
Explorer
0 Kudos

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.


Accepted Solutions (0)

Answers (1)

Answers (1)

markangelo_dihiansan
Active Contributor
0 Kudos

Hi Surya,

Convert the csv to xml first and then it will be easier to get the logic for summing the unique line items.

Regards,

Mark