12
Views
4
Comments
Solved
Duplicidade 
Question


Good afternoon

People would like to filter only the numbers without duplicating

Example table

1
2
3
3
5
5
6
7
8

how do i stay in this format
1
2
3
5
6
7
8
Solution

Hi,

You can do it in one of these ways, or as Nordin mentioned: you have a list of values, which come from an input or a query, for example, and you grab your input and use that action to filter out duplicates. Or for example, in an advance query, you can use the distinct (search google for SQL Destinct, and find how to use it). If you want use a aggregate, you could use Group By on one of the Project attributes to get unique records, but there could be a better way to rewrite your Aggregate and ensure it only returns what you need. 

Extra info:

Cheers



mvp_badge
MVP
Rank: #75

Hi Jone,

You can use the ListDistinct action from the System module to filter out duplicate elements.

Regards,

Nordin

Solution

Hi,

You can do it in one of these ways, or as Nordin mentioned: you have a list of values, which come from an input or a query, for example, and you grab your input and use that action to filter out duplicates. Or for example, in an advance query, you can use the distinct (search google for SQL Destinct, and find how to use it). If you want use a aggregate, you could use Group By on one of the Project attributes to get unique records, but there could be a better way to rewrite your Aggregate and ensure it only returns what you need. 

Extra info:

Cheers