Transform repeating data to unique data (1 reply)
David, you could hierarchise the data by that field.
Alternatively, you could sort by the field, then use a filter to remove the duplicates (assume that 'Product' is the field name):
%Product PreviousRecord("Product")
%Product PreviousRecord("Product")
I have nine items consisting of two product codes - each of them repeated, for example,
ProductA
ProductA
ProductA
ProductA
ProductB
ProductB
ProductB
ProductB
ProductB
How do I transform this list so that I just have a list of two items:
ProductA
ProductB
This is for including in a report.