Posted: Thu Oct 16, 2008 10:00 am Post subject: Help with NeoBase Distinct Values
I'm having trouble getting the Distinct Values to work in NeoBase. I have a spreadsheet and I want to remove all duplicate values. Can anyone help? Thanks.
Joined: Jun 20, 2006 Posts: 2051 Location: Midwest, USA
Posted: Thu Oct 16, 2008 10:25 am Post subject:
ginap wrote:
I'm trying to run a query and remove all duplicate records. The 'DISTINCT' button isn't working. Neither is the duplicates option in NeoCalc. Can anyone help? Thanks.
Welcome to the forums at trinity! You only need to post your question to one of our forums, so I've locked your other thread in the Random Whatnot forum. I've copied over the information you provided there, as it will help us solve your dilemma:
Joined: Jun 20, 2006 Posts: 2051 Location: Midwest, USA
Posted: Thu Oct 16, 2008 10:34 am Post subject:
Are there duplicates in the underlying spreadsheet? If so, I don't think the Distinct Values button will help you. As I understand it, that button removes duplicates that are "created" in the process of the query.
In terms of removing duplicates in a spreadsheet, does this thread provide any assistance?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum
