Input file name based on Excel input

[jonghr]

Hi,

I am relatively new to Alteryx and try to learn by Firehose.

I would like to control the file paths and file names through an excel workbook.

In the excel workbook I would log all directories, and filenames and file extensions.

This would allow me for other members of the organization to run the reports, see the variables, make changes if necessary and not needing them to get into the code.

How do I set this up, so I can use the different cell input to compile a full file path that can be used to reference an input file or output file?

[atcodedog05]

Hi @jonghr 

Refer to this weekly challenge you might get any idea.

Just pass the required file info into the macro it should work. Fullpath should be Path+Filename

Hope this helps : )