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.
Can you share your workflow?
I am writing my data into different sheets and with that I want record ID in each sheet.
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".
Thanks for the solution @DataNath