Merge the output of 4 workflows in 1 sheet in a set template

[ShantanuDagar]

Hey guys,

So I have created a workflow that requires 4 parallel flows and after some manipulations and comparisons, the final tool is The Join in each of the 4 processes.

The L and R anchors of the join output are of interest.

All the 4 Ls have a certain output and they need to be merged into 1 sheet (and not just a direct union)

Similarly, all the 4 Rs have an output and they need to be merged into another sheet with a similar template as above.

And then both worksheets (with different names) will be part of 1 excel file.

The sample outputs of each Joins (1 of the anchor, the other will be similar just different data) and how the final merged output of all the joins (1 anchor) must look are attached.

Some Additional info which might come handy: The data set in sample output is right now 5,6,5,6 in number but it can change. Maybe 0 in particular workflow or maybe 20.

Thanks for any help

[Qiu]

@ShantanuDagar 
I think one way is that we will provide a full path for each flow then join the data together.

[ShantanuDagar]

Is there no way of merging those different sheets in 1 as given in sample output?

With the headline over each data.