Copying columns unique values to new column

[msamps]

I currently use this formula on google sheets: =UNIQUE(‘Sheet1’!N:N)

Is there a way to do this on glide so that I don’t have to wait for the data to refresh and can have everything in realtime?

[Jeff_Hager]

Select colA from Glide Table

A few ways to approach this. Here is one way. You would do the following in your Catalog table: Make sure your table has a RowID column. Create a multiple relation that matches the name with itself. Create a Single Value column that takes First->RowID from the relation column. Create an if-then-else column: – If RowID is Single Value RowID, then Name The if-then-else column should contain a list of unique names

[msamps]

Im a little bit confused. Im not looking for entirely unique rows. I just want to extract on the unique values from a singular column so that there arent any duplicate entrys in my list component

[Darren_Murphy]

If you follow the steps in the post that Jeff linked to, you can use the resultant if-then-else column as a filter on your list. ie. only show records where the if-then-else column is not empty.