Alteryx Designer: Assigning row numbers to multiple source documents

Question

I am processing a batch of data comprised of multiple source documents to be output to a database table that uses both the source document name and the row number as a unique constraint. What is the best way in the Alteryx Designer workflow to assign document-specific row number values?

I've had to use a manual workaround: 1) Summarize tool to define the given batch's discrete source document names, 2) Filter by source document (copy and pasting names from summarize tool), 3) Record ID tool to generate row values per each document, 4) Join the data again and write to database.

Philip · Accepted Answer

Have you tried the Tile tool in the Preparation tool set? I think the settings you want is to select Unique Fields as your document name field. You can play with the other selection fields. The Tile_SequenceNum would be the record ID field.