Treating duplicate data in a dimension as a non duplicate

[124rooski]

I've got a data set with duplicate Book Titles that are rated with a score by different publishers. For every duplicate entry I want to actually treat it as a unique data value. I've tried using recno() and rownum() but it's just appending/assigning unique row/recno() which is not what I want. Any way to achieve the screenshot below for the expected output? Thanks all.

[morgankejerhag]

If you want to show each rating in a detailed table you will have to have a unique value in a column. If the title, publisher, rating and date is the same the rows will otherwise be reduced to a single.

If you don't have such then add a unique identifier to the table in the load script using for example rowno() and add that column to the table.