Conditionally create a record based on the presence of its sibling (1 reply)
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.
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?