Low code app : Retrieve unique value with a query

Solved427 viewslowcodeapps
2
0 Comments

Hi community,
I want to retrieve unique value and display this value in a grid.
For now I have a result with for example : A, B, C, A, D but I want to have only A, B, C, D (without the duplicated A value).
How can I achieve this goal? With a custom operator? If so, do you have an example?
Thanks

Gilles Bara [SLC] [DevOps Enabler] Answered question 12th December 2023

1 Answer

10
6.18K 0 Comments

You can do this with built-in functionality. Extend your query with an aggregate: count another column than the one you want its unique values from. Continue by grouping on your A, B, C,... column. This will give you a table with two columns: the unique values A, B, C, D,... and the amount of rows with that value.

Gilles Bara [SLC] [DevOps Enabler] Edited answer 12th December 2023