Ask Your Question
0

Deleting duplicate rows using filter does not work

asked 2018-06-01 01:14:39 +0200

RonJohn63 gravatar image

hello,

v5.3.7

I've got a four column list from which I'd like to remove the duplicates, transforming it from this:

DB Server   Date    Time    Source
Atlanta 05/01/2018  21:01:51    10.101.96.69
Atlanta 05/01/2018  21:01:51    10.101.96.69
Atlanta 05/05/2018  02:02:02    10.101.96.69
Atlanta 05/05/2018  02:02:02    10.101.96.69
Atlanta 05/05/2018  02:02:47    10.101.96.69
Atlanta 05/05/2018  02:02:47    10.101.96.69
Atlanta 05/10/2018  11:19:15    10.101.112.226
Atlanta 05/10/2018  11:19:15    10.101.112.226
Atlanta 05/10/2018  15:02:42    10.101.112.165
Atlanta 05/10/2018  15:02:42    10.101.112.165
Atlanta 05/10/2018  15:02:52    10.101.96.49
Atlanta 05/10/2018  15:02:52    10.101.96.49
Atlanta 05/10/2018  15:02:59    10.101.96.201
Atlanta 05/10/2018  15:02:59    10.101.96.201

to this:

DB Server   Date    Time    Source
Atlanta 05/01/2018  21:01:51    10.101.96.69
Atlanta 05/05/2018  02:02:02    10.101.96.69
Atlanta 05/05/2018  02:02:02    10.101.96.69
Atlanta 05/05/2018  02:02:47    10.101.96.69
Atlanta 05/10/2018  11:19:15    10.101.112.226
Atlanta 05/10/2018  15:02:42    10.101.112.165
Atlanta 05/10/2018  15:02:52    10.101.96.49
Atlanta 05/10/2018  15:02:52    10.101.96.49
Atlanta 05/10/2018  15:02:59    10.101.96.201

I've tried highlighting the columns then Data->More Filters Standard Filters and clicking No duplications and Copy results to, but all it does is copy the header row. What am I doing wrong?

edit retag flag offensive close merge delete

Comments

Is your problem related to this?

Xoristzatziki gravatar imageXoristzatziki ( 2018-06-03 04:38:36 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-06-01 07:41:06 +0200

JohnSUN gravatar image

Are you setting any conditions for filtering?

Filter

edit flag offensive delete link more

Comments

Do you understand, which conditions he wants to apply from his example? I'm not

kompilainenn gravatar imagekompilainenn ( 2018-06-01 09:34:46 +0200 )edit

I just assumed. :-) An empty table header without data can be obtained if no any conditions are specified. Most often "Not Empty" is enough

JohnSUN gravatar imageJohnSUN ( 2018-06-01 10:13:29 +0200 )edit

There are no conditions. I just want the duplicates removed.

RonJohn63 gravatar imageRonJohn63 ( 2018-06-04 13:15:45 +0200 )edit

Once more - there are condition: "Filter NON-EMPTY cells without duplications". Just try it :-)

JohnSUN gravatar imageJohnSUN ( 2018-06-04 13:39:15 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2018-06-01 01:14:39 +0200

Seen: 345 times

Last updated: Jun 01 '18