I am new to DRM and trying to get property value export without any duplicates. I have a custom property, I want export for all the values defined i.e all the defined values of that property as it is a string it has many values and those are to be used as members in ESSBASE so I want to define an export which gives out property values just one list without duplicates.
In export when i select column as "EProperty" only it gives :
All I want is to remove duplicates in the column as they are member name :
*Repeated value are to be removed , is their any way we can customize export like this.
On the Export profile "Style" tab make sure you check Remove Duplicates Based on Key and then on the columns tab go to Column Options
Now check the boxes for Primary Key against any or a group of fields which you want as the primary key.
In your case if just want the EProperty to be the key check the box against this fields and the export would filter out the duplicate rows.