Thanks Neil for the app. I was able to use that to replace the password (though for a single manually entered file only). In my case I might have more than one set of salesforce connectors pointing to different environments (2 in my case). What I was planning to do is to define a dummy worflow with all needed connections and later for the actual worflows to replace the credentials based on table naming convention, as the segregation login would work in my case if I go with table naming convention logic - including cases even where an usual target is playing the role of source (for e.g. only to pass delta records from source which are not already loaded to target).
Since I am new to Alteryx and regular expressions, it is taking sometime for me to understand/use macros and how to use regular expressions to obtain the desired results. I know that the app you wrote was meant to pull all files within a directory but I was not able to achieve that at my end.
At present, I need to factor how to read all non dummy files from the original folder, translate those with correct credentials using the table naming convention, and if possible to create a new directory and write all those actual files (without name changes) within the new directory - all within Alteryx framework.
I have not marked the post as closed as I might encounter some more issues down the line while developing the final workflow and might need some more help. Hope that should be ok.
Regards,
Rohit
