Back to forum list… Back to How Do I?...

Transform repeating data to unique data (1 reply)

David F
6 years ago
David F 6 years ago

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.

Support
6 years ago
Support 6 years ago

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")

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close