0

I have a excel sheet which contains data with ID and value mapping.In this sheet for one ID there may be multiple values.How to find and separate records from that.

id value
101 abc
102 xyz
101 pqr
102 sdf
101 kjx

there may be n number of records

Community
  • 1
  • 1
Abhishek
  • 25
  • 7
  • Can you explain what do you mean by separation of records? – Ravi Yenugu Jun 12 '14 at 18:27
  • i want to insert records in DB as a batch of common items.so 101 abc ,101 pqr and 101 kjx will be inserted in one go – Abhishek Jun 12 '14 at 18:31
  • Its sort of vague question, you need to give us something to work with here! where is the excel sheet? How are you importing data? Are you having trouble filtering or exporting? what DB ?what have you tried so far? if you can get the data inside some Data structure then you can loop through in java or something – Ravi Yenugu Jun 12 '14 at 18:37
  • i have added all the data from excel to a bean of id and value as string values ,now i want the separate list for all the common values as mentioned above – Abhishek Jun 12 '14 at 18:54
  • This is probably what you need http://stackoverflow.com/questions/780541/how-to-sort-hash-map – Ravi Yenugu Jun 12 '14 at 19:06

0 Answers0