I have a flow where I lookup order references via API with our transporters, to pull delivery information for performance and tracking purposes.
In this flow I have a number of conditional flows; check if order reference is valid and API returns response or error, check if a shipment has multiple shipment details etc.
Working with the conditional flows makes me go most of the way, but now I’m stuck in a condition where I need to have a calculated condition as well as a condition to check if source table is NOT empty - a combination of 2 of the 3 built in options. Is this even possible?
In flow below I tried to group the different parts of the flow;
A and B - First validation
If import is a success, A takes the flow to the C part, where multiple transformations are made, all derived tables are made if source table is NOT empty.
If import is a failure, B takes the flow to Z where data is prepared for output.
My issue is in the D and E tables, where I can either only derive tables made on a calculation or if source table is either empty or not - What I need, it seems, is a combination of a calculation and a source table that is NOT empty - Is this possible?? Or is there a workaround I haven’t found yet?