Write data to Excel as both a summary tab (all data) and a tab for each subject

[Uni_User]

I've got some output data (about 30k lines if it matters). It looks a bit like this:

Subject	Student number	Fee status
Maths	123	A
Engineering	234	B
Engineering	456	A
Computer Science	678	C
Maths	910	A

I have an output data tool set up that writes the data to an Excel file that splits the students by subject, with one tab for each subject (a tab for Maths, a tab for Engineering, etc.), like this:

What I also need is a tab in the same file that contains all the records, and I can't work out how to do this.

I tried adding a new output data tool to write the data to the same file in a separate tab, but unfortunately then I get the error that Alteryx can't write to the target file as it's already open, as both output data tools are trying to access the same file.

Is there a way to do this?

[Christina_H]

You'll need to use a Block Until Done tool to force Alteryx to complete one output before attempting the next.

[messi007]

@Uni_User,

Please see below

Attached the workflow,

Regards