Joining Data example for Purchase Order Headers and Lines

Clinton Jones
Clinton Jones Experian Elite
edited December 2023 in Tips and tricks

This workflow uses PO sample data

The PO header and rows, is joined using the order number

This workflow performs a date calculation, adds an average aggregation based on a product ID grouping and then produces a reduced list of records sorted by average days to fulfil.

You could consider this as a simple report workflow to indicate which products are fulfilled fast and which products take longer to fulfill as an example. The group step also hides columns