I have a table of auto parts with over 300,000 entries. I know there are some part numbers (PartNumber is the field) which are duplicated. How can I create an object which will identify them without changing the load script to include rowno()?
What about creating an object (maybe a straight table) and use PartNumber as a dimension and then count no of rows using a measure named 'NoOfOccurences" count(PartNumber), or take advantage of the hide zeros functionality and reduce the NoOfOccurences by one like this: count(PartNumber)-1
