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

Conditionally create a record based on the presence of its sibling (1 reply)

David F
6 years ago
David F 6 years ago

I have a dataset hierarchy of Record - Orders - Order Lines. Some of those order lines require additional order lines creating. I can apply a filter to the order lines to get the order lines that need an additional order line. I can use an aggregate transform to generate the additional order line. When I previewed the result of the aggregate transform against the filtered set of order lines, an order line was created when it shouldn't have been.

How do I only create an additional line if an order line is already present on the order?

Support
6 years ago
Support 6 years ago

David, the Aggregate will always create the record irrespective of the filter condition.

The filter condition is actually applied to each record for fields where the 'Allow Value Accumulation' property is enabled. (The documentation needs updating in this respect).

What you want to do is to add a filter after the Aggregate transform to remove any unwanted records.

Our training manual(s) demonstrate this.

One thing to note is that you have a three level hierarchy. If you are creating orders you need a two level hierarchy (Orders & Order Lines) as your top level must always map to the first level that you are creating.

Hope this helps.

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