Create dynamic range when exporting to Excel

[Megshipp]

Hello All, 

I am trying to create a recurring report that runs in Alteryx and then exports to excel into my formatted template. I was able to achieve that, but the trick is that every time I run the report, the range will change. 

So, I am trying to find a way to dynamically change the range in Alteryx every time it is ran. I used a count record tool and a formula that puts that at the end of my range, but I then can't connect it back to my data to put to an output tool that pulls in all my other data and not just the record count (I hope that makes sense...) 

Is there a way to get the count and add it as its own column? I tried the record ID tool, but that counts consecutively and not a total count. 

Let me know if any more information is needed. 

Thank you!

[binuacs]

@Megshipp After the count record tool add an append tool, connect to the source anchor . the main file should be connected to the T anchor of the append tool then do your formula 

[Megshipp]

Thank you. That did join my data back together, but now when I run the report it no longer puts the data in the report. I don't think I have my output tool configured correctly somehow even though I didn't change anything on it... I guess I need to? I think maybe it's because on the output tool when I pull in the template file it makes me choose a range, but that is what I want to change dynamically... Any idea what I'm missing?

[alex]

In your formula you have to account that you are not starting on row 1 so if the data is starting on row 2 then in the dynamic file name formula you have use [Count]+1.  So if you have 8 rows and are saving to range A2:D9 it will have the correct range.