Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Create Table from Unique Values in Other Table

2308 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Houck
4 - Data Explorer
4 - Data Explorer

Hi! A bit surprised I haven’t been able to find an answer for this, or figure it out myself.

I have a table that has duplicate values in one column. I want to return all unique values from that column into a new column in a different table within the same base. Ideally, I’d like the column in the new table to be the Name column.

How can I do this?

Thanks!

1 Reply 1

Turn the column with duplicate values into a LinkToAnotherRecord type field, ‘point’ it at a new table.