Run the entire Alteryx Stream Record by Record
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @dpinn!
You can use the Tile tool for this --> including a link to a previous community solution posted: Solved: A tool that splits one file into many files - Alteryx Community
Or check out this resource in the Knowledge Base: How To: Split Output Into Multiple Files with Specific Record Counts (alteryx.com)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
not really, this but this gives me an idea of how to approach the solution. let me try it out. Thank You!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!!!