![]() ![]() I have attached the screenshot of my alteryx work. So during My process I simply produced 3 part:ġ), I found the old "MasterKPI" excel file I need using directory and a macroĢ), within the path address directory tool generated, I managed to replace some of the strings so it become a new location path addressģ), I am trying to export this "MasterKPI" excel file out with the Run Command tool.īUT it doesnt seems work, I am assuming I missed something that cause it doesnt work. What I need is based on the following ġ), I have a excel file called "masterKPI" which contains about 10 tabs within itĢ), at the beginning of every month I need to manually "SAVE AS" the file into a new locationģ), I am trying to reduced down this manual step in the alteryx as I will use it in many other workflow as well I have downloaded your workflow and I found this is most close to the issue that I need to solve, I have created a process according to your idea in the workflow. Any help or suggestions you can provide will be greatly appreciated. I do not have direct access to the underlying database. The only way to export the text file is through a menu system. I am using PowerTerm to automatically process a set of commands that ultimately exports a text file that I want to pick up an process with Alteryx. In case you are wondering, I am including the path to the PowerTerm executable when using the Alteryx Run Tool. I can navigate to the Powerterm directory and then run ptw32.exe filename.psl without any problems from the Windows command line. Switch to the View tab, scroll down until you see Hide file extensions for known file types, and remove the checkmark from that option. In Windows 7, click Organize in the top left and select Folder and search options from the menu. The other pops up a message stating "couldn't open file "filename.psl": No such file or directory". In Windows 8 and 10, go to View and set a checkmark next to File name extensions. This is the standard file extension for batch files and is recognized. The system cannot find the file specified. The recommended file extension for a batch file in the Windows operating system is. The first approach results in "Failed to run external program. I tried to include it as part of the Command and seperately as the Command Argument. The problem I am facing now is how to get it to then execute the script (.psl) file. Based on bits and pieces of information I found in this discussion, I was able to get to a point where it opens PowerTerm. I am interested in using the Run Tool to open PowerTerm and execute a script file. Slightly different than the discussion topic, but this discussion is what helped me get to the point I am now at. ![]()
0 Comments
Leave a Reply. |