Hi everyone,
I’m practicing for the AutomationEdge Developer Certification and I’m stuck with Shared Workflow execution.
Scenario
I have created a shared workflow (WF_Validate_Bookings) and a main workflow (WF_Main_Travel).
Shared Workflow
The shared workflow performs the following:
Reads CustomerBookings.xlsx
Validates TravelDate > BookingDate
Invalid records are written to an Excel file
Reads CustomerDetails.xlsx
Validates MembershipStatus (Yes/No)
Merge Join with valid booking records
Finally uses Copy Rows to Result
The shared workflow executes successfully.
The log for Copy Rows to Result shows:
Copy Rows to Result
R = 8
which indicates that 8 rows are being copied to the result.
Main Workflow
The main workflow contains:
Workflow Executor
↓
(Result Rows after execution hop)
↓
Sort Rows
For the Workflow Executor:
Selected “This output will contain the result rows after execution”
In the Result Rows tab:
Target Step = Sort Rows
Added all expected fields manually (TripID, CustomerName, Destination, Mode, BookingDate, TravelDate, Email, MembershipStatus)
However:
Workflow executes successfully.
No errors are shown.
Sort Rows receives 0 rows.
Preview Data is empty.
I also tried using Get Rows from Result by manually defining all fields, but it still returns no rows.
My Questions
Is my Workflow Executor configuration correct?
Is there any additional configuration required in the Result Rows tab?
Should Copy Rows to Result be connected directly after the Merge Join, or can there be an Excel Writer before it?
Is this a known behavior in AutomationEdge 8.4?
Has anyone successfully implemented a Shared Workflow returning rows using Workflow Executor in Process Studio 8.4? If yes, could you share the expected workflow structure?
Any guidance or screenshots of a working setup would be greatly appreciated.
Thank you!
