RecordID in separate sheets while creating output extract
- 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 Community,
I am facing an issue while creating a excel extract with different sheets through output tool, I want to have record ID in each sheet starting from 1. Please help.
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you share your workflow?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am writing my data into different sheets and with that I want record ID in each sheet.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @tushar_portal, I've just answered what looks like to be the same ask here: https://community.alteryx.com/t5/Alteryx-Connect-Discussions/Adding-RowID-while-taking-output/td-p/1...
In the Multi-Row Formula, where I have grouped on [Region], you'd just change that to the field you're splitting the data into different tabs on. Likewise, as mentioned in the linked post, you'll also need to change the filepath in the Formula expression to your own location/filename before the ".xlsx".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for the solution @DataNath
