Running Command Batch File from temp folder

[NoahNathan]

Struggling to run external .bat file from the %temp% folder. Any idea how to do this?

I get this error:

[patrick_digan]

Hi @NoahNathan. On first glance, your output is .csv but you're trying to call a .bat. I'm assuming your output should be .bat (although you would indeed select the csv option in alteryx with no delimiter) and see if that helps.

[NoahNathan]

It is part of a larger macro. I essentially use it to write a command as a .bat file (called .csv here but is atually renamed to .bat), then I wait until its completed to run the .bat file in the "run command".

This issue is not the .csv file. The issue is that the external program "%temp%.BigQueryBatchFile.bat" cannot be found.

[patrick_digan]

Ah I see. So can you show me where %temp%BigQuerybatchFile.bat is being created? 

[NoahNathan]

In the default folder: C:\ProgramData\Alteryx\Engine as that is what the %temp%\ does

[patrick_digan · Accepted solution]

%Engine.TempFilePath% should be equivalent to %temp%. Let me know if that doesn't solve it!