I have an excel file which has column “CustomerNo” and it contains a String and Double Value. I have to get all the detail of this customer.
For Example: First I will select 1 customer,
- Customer Name: “AB0001”.
- Keep all the records of this customer.
- Based on this record get the Sum of Cash.
- Based on this record get the Min days
- Write this data(which we get from Point 2) to another excel file.
- Now repeat for the next customer and do step (1-5)
Below img is just an overview:
So I am stuck doing this as the CustomerNo has string n double value.
Any help on this?