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 ?

Thanks,

  • Ravi

Answers

  • 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
    OpenText
Sign In or Register to comment.