Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email for assistance.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Change Output Path in HDFS (output tool)

8 - Asteroid

in output tool, Is there a way to dynamic change data path result for HDFS via connection 



hdfsc:Hostname=<<Host Name >>:<<Port>>;User=<<User>>;Password=<<PASSWORD>>;Authenticate=false;Tempdir=/tmp;URL=<<HOST NAME>>:<<PORT>>/<<APIGATEWAY>>|||/dev/result/data_.csv


I have scenario where I have to save different data path base on  environment  ( dev/prod/qa) 


I was wondering is there a possible way to change data path in hdfs ( change /dev/result/data_.csv  values)


Image 1.png


Since Append/prepend/change file would only change name of the file not location data.

and I did with entire path which I require copy who string which contain user and password which I concern on security.


Are there recommend solutions?





You can use a concept called a Batch Macro. This a great article that will help you get started.


Using the Control Parameter module you will be able to feed in the values you'd like to overwrite the path with and the Action Module will allow you to choose which bit you would like to replace - see the below





8 - Asteroid

Hi @MichalM  


Thank you for the idea, I manage to create simple batch macro that  can change enviroment folder in hdfs. The article is really helpful.