Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

RecordID in separate sheets while creating output extract

tushar_portal
6 - Meteoroid

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.

4 REPLIES 4
Link
7 - Meteor

Can you share your workflow?

tushar_portal
6 - Meteoroid

I am writing my data into different sheets and with that I want record ID in each sheet.

tushar_portal_0-1668418543397.png

 

DataNath
17 - Castor

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".

tushar_portal
6 - Meteoroid

Thanks for the solution @DataNath

Labels