Home Analytics Developing analytics applications
The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

How to get distinct values from the data set in the data design?

Hi Experts,

In one of my business case, I need to create a data set with distinct values in the data design file. I know we can achieve this using cross tab but i have some limitation from the requirements point of view. so i need this to be implemented in the data set level. Can any one suggest me the solution ?


  • Ravi


  • If the data set is populated by a query, simply do a SELECT DISTINCT query. If you aren't running a query, then you will need to use a Scripted data source and write code to eliminate duplicates.

    Jeff F.
    Customer Support Engineer I
Sign In or Register to comment.