Create dynamic range when exporting to Excel
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.