Adding RowID while taking output

[Nikhil9403]

Guys, need your expertise on one of the tasks I am working on;

1. Need to get the output having sheet names same as values within 'Region' column from the Input file.
2. I want to have 'RowID' as the first column in the output file.

I have attached 'Input' file to work upon, and output file just to make you guys clear on my request.

[DataNath]

Hey @Nikhil9403, something like this should get you over the line.

We use the Multi-Row formula to create a grouped RecordID, i.e. a record ID restarting every Region.

We then build a custom filepath so that we can feed it into the Output Data tool to split the dataset on Region.

The select just places the RecordID at the front as it's not an actual RecordID which would, by default, be placed in the first column.

Note: You'll need to change the path specified here to wherever you want to save the file and obviously change the name. So you'll need to edit everything before the .xlsx part in this expression:

[Nikhil9403]

Thanks @DataNath,

That was helpful. 

But I also found an another solution with the help of 'Tile' tool.

It also served the purpose.

[DataNath]

No problem @Nikhil9403 - happy to help.

Yep - the Tile tool is also another option for creating grouped RecordIDs! :)