Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Run the entire Alteryx Stream Record by Record

dpinn
5 - Atom

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.

5 REPLIES 5
adamweaver39
9 - Comet

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)

TimN
13 - Pulsar

Is the goal to output an output file per row?  If yes, this can be done several ways.  The simplest way is to take filename from a field option in the output tool.

dpinn
5 - Atom

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.

dpinn
5 - Atom

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

dpinn
5 - Atom

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!!!

Labels
Top Solution Authors