This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
I kept circling around the Tile tool yesterday but the necessary detail kept eluding me -- and so in order to get the data where it needed to be by EOD, I made a mess of the workflow to achieve the desired end! Now the flow's much more elegant -- and will be perfect for running more data. Thank you, Philip (also my brother's name)!