Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 07, 2016 at 06:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded