I have a data set that looks like the following (on the left), all of the values for each category are the same. I want to display it in glide like the table on the right, but when trying to filter for duplicates I can only remove all duplicates (not just show the first one). Any ideas? Thanks! [Screenshot 2024-11-23 at 3.09.09 PM]

Add a row id column in the base table. Create a new tab in your google sheet, and at A1, enter: =UNIQUE('Name of your first tab'!A1:B ; false ; false) It will give you only unique rows.

This is a common method using the same table. Then you can just filter the table. [image] Filter to display DISTINCT (or Unique) rows based on specified columns Feature Requests I typically use or recommend the following method: Make sure there is a Row ID column. Create a single Relation or Query to link similar rows to themselves based on similar values. Create a Lookup or Single Value column to retrieve the first matching Row ID from the Relation/Query. Finally create an IF column comparing the row’s Row ID to the Lookup/Single Value column and return true if there is a match. Only the first occurrence will be a match.

Is there any functionality like that in glide? I just copied over what I am trying to do in google sheets for easier visibility

I mean, you could, but you will have to add every key by hand on the first column, then add a relation column and lookups to the other related columns. You could use schedule workflow to make a copy of each unique element in another table, but that may not be the best workaround…

I think you should prioritize using the method Jeff suggests, and move everything you can to Glide Tables.

[image] MaximeBaker: Create a new tab in your google sheet, and at A1, enter: =UNIQUE('Name of your first tab'!A1:B ; false ; false) It will give you only unique rows. We stopped recommending spreadsheet formulas at least 2 or 3 years ago. They are almost never required, except for a very few rare cases :slight_smile:

I think I understand what you’re trying to achieve. I recommend downloading your Google Sheet and importing it into glide as a new Glide table. You data table will look something like this: [image] And you can create a helper table where each row will automatically be 1 of the categories: [image] First we lookup all the Row IDs: [image] Then we get the index of the current row: [image] Then we lookup all the categories from the data table: [image] Get Unique Elements from the categories: [image] Then a single value column to retrieve the category based on the row #: [image] 6: Finally a relation and lookup: [image] Make sure you have enough rows in the helper tables for the number of categories.

How would it be possible to automate that from Glide table?

See the link that Jeff gave. That’s probably the simplest method.

Removing duplicates

Ask for Help

Jeff_Hager November 23, 2024, 10:05pm 3

This is a common method using the same table. Then you can just filter the table.

Topic		Replies	Views
Copying columns unique values to new column Ask for Help	3	414	June 22, 2023
Unique Function via Glide Table Ask for Help	5	710	July 4, 2022
Filter to display DISTINCT (or Unique) rows based on specified columns Feature Requests	5	4000	June 18, 2024
Unique Element Ask for Help	1	408	April 15, 2022
Populate data Ask for Help	4	291	August 30, 2023

Removing duplicates

Related topics