Output to Specified Ranges Across Multiple Sheets

Question

Hello!

I have a car sales dataset that I want to split out by state across different tabs, which is easy enough to do. But within each of those tabs, I want the output to start at A10, not A1. The attached picture is a simple workflow I have to test it out, but whenever I run it the output always starts at A1 even when the declared output range starts at A10. I think that splitting out the output into tabs by state is overriding the original output reference in the workflow, but is there a way to adjust it so that the output can start in A10 and be split by state into tabs?

I would like to start the output a few rows down because depending on the data, I will have notes, and it would be nice to automate the process of creating those rows without a macro.

Thanks!

Screenshot.png

SPetrie · Accepted Answer

Ive never had good luck with Change File/Table name and ranges, I like to replace the entire file path when outputting to specific ranges.

Build your output file name, sheet name, and range all in one field and then just substitute the whole thing.

caltang · Accepted Answer

Adding to @SPetrie 's comment...

You can use a formula tool to have the sheet name and cell range in the expression. Then you can have a full output path which can then be used in the output data tool.

If you want to write to a single file with multiple sheets, you can either:

1. Use dyanmic rename and give each sheet 1 2 3 4 as prefixes for the header names, then Union them all, and used Block Until Done - then use dynamic select to have those field names starting with the prefixes defined, then output each one - you will not have issues.

2. Use control containers to execute based on your required order.