Skip to Content
0

How to implement a table in a Calculation View using a distince column method

Dec 06, 2016 at 05:58 PM

22

avatar image
Former Member

I know how to apply a filter to a table in the Calculation View. However in this scenario, I need to do a DISTINCT on one of the tables. Is there a way to build a projection object in the graphic view which permits distinct selection.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
Dec 07, 2016 at 06:23 AM
0

With a projection node no distinct values can be created using pure modeling options. You have to create an Aggregation node using the fields for which you wanna have distinct values.

If you really wanna use a projection node (for whatever reason) the only option is to use a SQLScript table function which implements the distinct logic.

Regards,
Florian

Share
10 |10000 characters needed characters left characters exceeded