Run the entire Alteryx Stream Record by Record

Question

I have a text input with 3 rows and I would like the entire stream to run with one row at a time and generate 3 output files. Is there a way to do this?

The number of rows might change in the future, so trying to do it a way that it automatically picks what's required.

dpinn · Answer

Not sure, if there is a better way but this is what I did. Created the record ID for the rows, then all other datasets I am using, created duplicate rows using the Generate Row Tool, this will give me a new column with numbers. Which then I replaced to Record ID after Unioning.

Finally, used the output tool where I selected the RecordID as a field to append, which grouped all the records and gave me separate files as required.

Even though there is a manual step involved, this is a lot better than going field by field in the text input. Let me know if you have better suggestions. Thank You Again. Cheers!!!

image.png

CreateDiffOutput4Rows.yxmd

dpinn · Answer

not really, this but this gives me an idea of how to approach the solution. let me try it out. Thank You!

dpinn · Answer

Rather than splitting the records.

What I am trying to do is let's say I have 3 rows. Each of these rows, I perform a set of spatial, union, and other operations and get a unique output file for the results for each of the rows.

Hope this makes sense. Appreciate the quick response.