Notifications
Clear all
Topic starter
Hello,
I'm encountering an issue with a scenario that's currently blocking me, and I'd appreciate some assistance.
My requirement is to generate a series of material orders for suppliers, with each order being independent based on its order number.
This means I need to create separate files for each supplier and for each order.
I've included a diagram to help illustrate the process:
The data structure is as follows:
The process flow is as follows:
In my current callin.io scenario, I query the supplier order table. This returns the various records in this format:
My objectives are:
- Group all records by their respective order numbers.
- Separate these orders based on the suppliers.
- Generate individual documents for each of the filtered records.
I'm unsure if the optimal approach is to begin by segregating the records by order number using the "Table aggregator" function.
Could this be the initial step in the process?
Using this option, I've managed to group the different records by order, but I'm unsure how to proceed to achieve the second objective of grouping by suppliers.
I look forward to your thoughts on this.
Thank you
Posted : 15/11/2022 6:03 am
Topic starter
I've been considering a different approach to configuration.
This time, I began by querying the primary table, which is the order table.
After retrieving the line item records that constitute each order, I'm using an iterator to separate each line item.
Then, I identify fields like products, suppliers for each item, and other necessary data.
However, I'm unsure how to proceed with grouping by order number, as each order can have one or more records, and I don't know the exact count.
Thanks
Posted : 15/11/2022 7:25 am
Could you help with this?
I need to accomplish something similar to this and then paste the result into a Google Docs template.
Posted : 24/04/2023 5:09 pm