4 workflow writing output to single sheet

Question

Hey all,

I have a workflow which have 4 pretty huge parallel processes and all 4 processes end with a join tool.

The L,R anchors of join tool (4L, 4R) will write to same excel workbook.

All 4L will write to sheet 1 simultaneously in a different specified range using overright range and preserve formatting selected.

All 4R must write to sheet 2 in the same excel file with same configuration as above.

The file which they will be writing exists ofc.

Any idea how to do this?  And how to configure flow from here on maybe using BUD tool or something else

Felipe_Ribeir0 · Answer

@Isha_Gupta , I believe that if you changed the writting order, it would work. But yes, sometimes you need to adjust it. The best way is to keep the process in order (less rows -> more rows).

LouisSwanepoel · Answer

@Felipe_Ribeir0 wrote:Hi @Isha_Gupta

If your problem is that the processes are trying to write to the file at the same time, you can use a logic like this (came from this topic: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Creating-2-Sheets-with-different-names-in-1-outcome-file-excel/m-p/1057411#M261564)

to make a "cascade" and write one range after the other.

I have found instances where I still run into issues using the mentioned technique and resolved it by moving the connection 2 on the Block to connection 3 and adding a count records to connection 2.

Felipe_Ribeir0 · Answer

Hi @Isha_Gupta

If your problem is that the processes are trying to write to the file at the same time, you can use a logic like this (came from this topic: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Creating-2-Sheets-with-different-names-in-1-outcome-file-excel/m-p/1057411#M261564)

to make a "cascade" and write one range after the other.