20

It's going to be one of those days. I already know.

Comments
  • 3
  • 3
    The long explanation:
    This excel file has 70+ columns and 450,000+ rows. I had to identify unique rows using up to 10 cells. The file has about 430,000 duplicate values, but they are imperfect duplcates. Then, after identifying the unique rows, I had to copy that over to a second file.
  • 1
    @hackedranger why you have an excell table with 450k+ rows???
  • 1
    @hackedranger please don't tell me it used to be an "Excel DB"
  • 0
    @sergiolarosa89 when you do a whole db in excell. Yewh you can do stuff that you'd normally use mysql for too. But well slower... But you can.
  • 1
    To clarify a bit, this is basically meant to be a snapshot of a small portion of a large database. We are trying to process its parts to integrate the data from it into our own databases. The old database that we are pulling from is inaccessible to us, due to reasons. There's too much red tape for me to explain more though.
  • 2
    Are we just going to ignore that poor dev is using Internet Explorer? RIP
  • 0
    @sergiolarosa89 yeah, it's not a real thing just people using spreadsheets as databases, I've seen it.
  • 2
    @samsepiol On the slightly fortunate side, I get to use my browser of choice for most things. I just have to use IE for certain vendor sites, because our vendors are bad people.
  • 0
    Good to know Excel supports GPU ;)
Add Comment