Dynamic Input "Internal Error"

One of my users found this issue that I'm able to recreate, but not solve. We are getting an "INTERNAL ERROR" message when trying to pull in a dynamic input. I am able to load the file when using a regular input tool, as shown below. I've done many dynamic inputs like this and have never seen an "INTERNAL ERROR" before. The warning also states that the are a different number of fields than the first file; however I am only trying to load one file. The template in the dynamic input is the same file. Any ideas what could be causing this and how I can solve it?

Attached is a parsed down and scrambled version of the file.

Workflow

Input

Error Message

Accepted answers

philipmannering

This is very bizarre. Looks like it's related to the Sheet Name. If you change the sheet to, say, ABC then the problem goes away.

Alternatively, in the Formula Tool, create the FullPath as,

[FullPath] + '|||AIC$'

...i.e. with a dollar sign at the end.

Not sure why you need the dollar sign, but this should solve your issue.

All comments

philipmannering

This is very bizarre. Looks like it's related to the Sheet Name. If you change the sheet to, say, ABC then the problem goes away.

Alternatively, in the Formula Tool, create the FullPath as,

[FullPath] + '|||AIC$'

...i.e. with a dollar sign at the end.

Not sure why you need the dollar sign, but this should solve your issue.

@PhilipMannering , thanks so much! That worked like a charm. Very strange, I've never had that issue before.

Alteryx doesn;t handle unusual spreadhseet names.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15865

MarqueeCrew 13708

apathetichell 13703