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