This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
I have created a macro, which includes an input data tool within the macro. I am having issues with inserting a generic file address for this input data, as once I pass over the alteryx package, I do not want the user to have to open the macro, and change the address of the input data tool within the macro. Assuming the file address is of the input excel is "C:\Users\a\b\c\d\e\f\g.xlsx". When I change it to ".\f\g.xlsx", i get an error stating that the file cannot be located.
I am not sure if I understand the question correctly.
If you build a flow using a macro, you can distribute it already with the indicated file.If the user wants to point to another one, he can do so without entering the macro. However, when the user will build a flow using your macro, he will have to select the file himself, there is no option to set a default file.
The file indicated in the macro will always be replaced with the one indicated in flow.The template used in the macro will only be used when editing the macro, but I assume users will not do so, and even if they then select their own file.