How to get distinct values from the data set in the data design?
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 ?