This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
maybe @DavidP has a better idea, because I am not quite sure what's the best way to achieve this.
Exporting data to specific cells or ranges is no problem with the output tool, but the header issue will remain. Usually I'd do all the formatting in the Reporting tools but I don't see a way to write the Export to a specific cell with the Render tool.
Sure, you could use two Output-Tools and write Header and Data differently, but I think you are not able to have Header Cells that span over two columns (or more) with that. You would also need a Block-Until-Done tool for this. It's probably the closest to your solution from my point of view. Maybe David has something in mind.
Sorry for the no-show to your tag last time. I have been busy preparing Alteryx Workshops at work lately and did not find the time to check my community notifications.
If you're writing to an existing Excel file, you have to use the Output data tool, since the Render tool will completely overwrite any existing Excel file.
The Output data tool can't create merged cells, but can write to them if they already exist. Also, since 2020.1 you can now retain any cell formatting when overwriting data in a sheet or range.
If you were to use Output data tools to write data to specific cells, you'd have the generate all of it as data rather than column headers and set the Output data tool to write the data only without headers.
I'm attaching an example of how you can create merged headers with a combination of Table and Text tools. You can also use empty Text tools (containing just a space) to insert rows and columns between and above tables. It will be tricky to manipulate the tools to get the data to the exact cells you want, but it's doable.
My point was 2) in combination with predefined range that you want to write to. If you are fine with single cell headers, you could just use the new Output options:
You could do this in a couple ways. I'd probably use a Batch Macro. Union all the data with file name included. You split your data again in the batch macro. A Block Until Done is needed to get separated writes for Header/Data. For this to work properly you would need Range-Definition for each source, but you would need this anyway.
Ohh. Sorry for the technical terms. I personally have never used 2018.4 (I started using Alteryx 6 month ago with 2019.4). I have to check if I can get access to a 2018.4 version and see what Tools/Features are available there.
Have you tested @DavidP solution? He also attached a workflow for you to test it out.