XDF Output Tool Error: doTryCatch error

[aHogancamp]

Does anyone else keep getting an error on the XDF Output tool of "Tool #10: Error in doTryCatch(return(expr), name, parentenv, handler):"? I have an extremely simple workflow where i'm reading in a ".yxdb" file, running it through a select statement, and exporting it to .xdf output permanent location. I have tried exporting just one column with 100 records as a number and as a string, I've tried exporting different columns, and I've tried exporting multiple columns. Moreover, I've tried the non-permanent location (temporary table). I cannot, for the life of me, get this XDF Output tool to work correctly in order to use the Microsoft R Client "rx" functions. I emailed Alteryx Support and am working with them, but I'm curious as to if anyone else in the community has come across this problem.

[aHogancamp · Accepted solution]

After working with the Alteryx support team (thanks Jessica Silveri and Criston Schallenger!) on the XDF Output pre-made macro, there is a missing piece within the sub-macro R Tool in the temp.dir initial definition about 1/3 of the way down. Note that the error came from a temporary folder and not from where I told it save the XDF Output. The code should be: 

temp.dir <- scan(what = character(), nmax = 1, sep = "\n")

instead of the pre-created definition:

temp.dir <- scan(what = character(), nmax = 1)

which is without the "sep" command. This means the R "scan" function defaults to looking for "white spaces" as separators. I had white space in my "Program Files", which the macro didn't know how to get around and was causing the error "doTryCatch" in my Alteryx results output.

I haven't seen many discussions around XDF files within this community, but I wanted to let others know what problem I faced in the XDF Output pre-made tool and how to solve it.