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
Solved! Go to Solution.
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.
Can the DI tool assume the same template as what's being input to it? In other words, do you have to specify the template?