In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

How can I use filenames as variables in Input Data

franc1s
8 - Asteroid

I have a semi-unstructured data file. The unstructured part is a header section which is somewhat "free-style". 

 

At the moment I am using the input data tool 3 times to pull 1) 2 items from a header section and 2) pull delimited data from from the structured part of the file. So, i all cases, I am pulling data from (each) a file with 3 input data tools.

 

For 1) I am using the "start row", "row numbers to read" and special delimiters to read the rows from the unstructured data that I am interested in.

 

As such, the 3 data input tools have a special configuration each, although they are linked to the same file.

 

The problem arises when I want to loop over a number of files. How can I keep the input file names in sync across the 3 input tools?

 

Is there a better way to do this altogether?

 

Thanks very much in advance.

 

11 REPLIES 11
franc1s
8 - Asteroid

Capture_1502.PNGThanks @atcodedog05! Would this be more efficient? I didnt think of leveraging the file name, but, its a good idea, also to have some kind of traceability of the data.

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @franc1s 

Cheers and have a nice day!

Labels
Top Solution Authors