on 05-27-2018 9:10 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.