Is there a way to use environmental variables in Alteryx Designer in the Input Data tool?
Something like this, where the Input Data points to a file on the desktop no matter what user uses the tool.
C:\Users\%userprofile%\Desktop\Countries.xls
Hi @ejogion,
That will not work directly, however what you can do is have a text input with 1 cell called [EnvVar] and the text being "USERPROFILE".
That then feeds into a formula tool:
[Path] = 'C:\Users\' + GetEnvironmentVariable([EnvVar]) + '\Desktop\Countries.xls'
Feed that into a Dynamic Input Tool to change the FullPath.
Kane
This is correct and solves my question. Thank you.
The only problem is the data I have coming in has different schemas. The macro I was building is supposed to fuzzy match column headers, standardize the naming using a master file, and union the files. There's no way to change the template with every input right? The macro Action tool doesn't show anything to indicate this.
