this post was submitted on 27 Oct 2023
4 points (100.0% liked)

LibreOffice

463 readers
6 users here now

LibreOffice is a powerful free and open source office suite, used by millions around the world.

founded 2 years ago
MODERATORS
erAck@discuss.tchncs.de
4
Finding duplicate entries by several criteria (szmer.info)
submitted 1 year ago by nudnyekscentryk@szmer.info to c/libreoffice@discuss.tchncs.de
5 comments fedilink hide all child comments
 

I have a csv file of orders from a business I run the web shop for, around 30 thousand entries total. I would like to FIND all entries which have a duplicate in the base: same customer, same total due amount and placed on the same day (some customers make repeating orders but over longer timeframe).

I found a help article regarding removing duplicate values, but it doesn't really apply to my situation, because I want to remove UNIQUE values.

How would I go about that?

you are viewing a single comment's thread
view the rest of the comments
[โ€“] JackSkellington@lemmy.world 1 points 1 year ago (1 children)

That would work for a 1 dimensional table. If you have many columns, you either mess up the following columns or you get back to the beginning. With lists that works wonderfully

[โ€“] nudnyekscentryk@szmer.info 2 points 1 year ago

It seems to have worked