List of unique values

Queries and Resources
1

Hi

Have an api query that returns a table of values, some of which are repeated

Would like the as a unique list without duplicates

This:
Category

car
motorcycle
car
car
boat
car

Becomes:
Category

car
motorcycle
boat

Much appreciated

2

Use a JSON SQL to get unique values.

Select distinct MyField
from {{myQuery.data}}

You can also do it in raw JS:

2 Likes
3

If the JS route seems daunting there's also the already included lodash library functions:
https://lodash.com/docs/4.17.15#uniq

2 Likes