Dynamic File Path Help - workflow where users may have different folders in "Full Path"

katief

Hello,

I share workflows with others on my team and typically we save our own versions of workflows with our usernames and file paths in the input and output files. I am looking for a way to dynamically pull in our file paths. I am newer to Alteryx so I don't have the best grasp on terminology, but I will do my best to explain. 

To get to the same file, my file path will look something like this: 

C:\Users\MyUsername\OneDrive - CompanyName\Team Name\abc.xlsx

But my coworkers file path to get to the same "abc.xlsx" file path will be

C:\Users\CoworkerUsername\OneDrive - CompanyName\Department Folder\Team Name\abc.xlsx

I believe this is because where we have saved our OneDrive shortcuts, but I am wondering if there is a way to set up a file input so it will also work for my coworker(s) when they try to run the folder, even if they have additional steps to get to the file.

If the folders were the same, I would be using a text input tool, followed by a formula tool with GetEnvironmentVariable('OneDrive'), which pulls in C:\Users\MyUsername\OneDrive - CompanyName, + the file path "\Team Name\abc.xlsx|||Sheet1", then dynamic input changing the entire File Path, but of course this wouldn't work for my coworker if they have the extra "Department Folder". 

Thank you in advance for any help!

Genevieve

Hello @katief 

We have a similar set up in my team.

I simply have adapted the formula with an IF condition

IF GetEnvironmentVariable('username') = 'user1'
THEN 'C:\Users\user1\OneDrive - CompanyName\Team Name\abc.xlsx'

ELSE 'C:\Users\'
+ GetEnvironmentVariable('username')
+'\OneDrive - CompanyName\Department Folder\Team Name\abc.xlsx'
ENDIF

This way, it applies a variation if the username is different. If the department folder varies per person, you could also use a field which would dictate the variation for each individual, either via another ELSEIF or by plitting the string as above.