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

Filter unique lines based on column value (2 replies)

Hannah Munro
3 months ago
Hannah Munro 3 months ago

Hi 

I have set of data with multiple lines per company ID (with a number of other fields as well)

I want to filter to show one line per company, how would you do this?

thanks 

H

Arline Welty
3 months ago
Arline Welty 3 months ago

Did you try a hierarchy transform where the key = Company ID? 

Support
3 months ago
Support 3 months ago

Arline, thanks.

Yes, a hierarchy by the Company ID will do this.

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