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.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
Possible with a few specific conditions... After you select the sheet you want to save it to (Sheet1, for example), you can modify the configuration of your output tool to include the cell references for the range you want to paste your data in. But the trick is that (I believe) you have to know the exact range where your data will be posted.
So one way to do it could be to determine which columns your data would be pasted in based on the number of fields included + your start column (so B:I per the example below), and then determine the number of rows based on a count of records (let's say 2 records for this example, plus a header row, so it would be the start row + 1 + 2). You could then create a field that indicates the "Sheet name" by concatenating the sheet, a $ symbol, and the row/column reference based on your data.
So in this example, the field would be created with a formula that creates something like C:\\Documents\FileName.xlsx|||'Sheet1$B2:I4', and then you can choose the option in your Output file tool to replace the entire field path with this field (un-check the box to include field in output). The data will then be output to whatever range you specified.
Not the most straightforward of solutions, and I would say it's likely someone else out there has a much faster/more streamlined way to do it 🙂 But for an unknown output range in Excel, this would potentially do the trick? Let us know if you want to tinker with this idea (or another one) some more!
@mat_ste_cb - I think the issue here might be that you need to include the header row in your specified range? Alteryx has no problem writing to a range that has data, but if you don't incorporate the header row, then it will try to write your data starting with the header in J6, which will extend the data down to J22, which is outside your specified range.