Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.
Free Trial

Alteryx Designer Desktop Discussions

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

Dynamic tool to pull a single row of data from an excel file continuously

rmahurin
5 - Atom

I'm having trouble coming up with a way to extract each individual row of data continuously into a seperate data file. Is there a way to pull a singular row of data from a file continuosuly? Meaning that each row of data within the orignal file transforms into it's own distinct file.

3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

Hey @rmahurin,

This is definitely possible, all you need is to populate each row with a column containing its destination file then select the following options in the data output tool:

IraWatt_0-1663172829609.png

 

Example attached.

 

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

rmahurin
5 - Atom

Hey Ira, 

 

Thank you! I was able to get my workflow working with your provided solution. Thanks 

IraWatt
17 - Castor
17 - Castor

Great to hear @rmahurin 😄 Have a good week!

Labels
Top Solution Authors