I would like to create a new GLIDE table which brings in the unique values from another table… is there an easy way to do that ?
I can get the data I want to see, but as a calculated value it creates an array of each row… but I would like rows created for each value…
Yes. Do it like this:
- Add enough rows to your table to cover the maximum number of unique values
- Add a RowID column
- Add a Lookup column that targets the RowID column. This will give you an array of RowIDs
- Add a Find Element Index column. This should target the array of RowIDs, and look for the RowID. This column will give you a incrementing number in each row, beginning at zero.
- Add another Lookup column that targets the column you want unique values from.
- Add a Unique Elements column that targets the previous column.
- Finally, add a Single Value. This should take X from Start of the previous column, where X is the Row Index number.
1 Like
wow thats a handful:) I went on the oldschool direction… Google spreadsheet, unique(query(…))
thanks for your time and effort.
Using a sheet formula is fine, as long as you don’t care about the sync delay.