topic Re: Alteryx Gallery App input and output problems in Alteryx Server Discussions

Alteryx Gallery App input and output problems

Philip — Mon, 21 Aug 2017 21:54:00 GMT

I've created and posted an application to Alteryx Gallery, but I'm having two problems. The application takes a file upload and the name of the output file through interface tools.

Here is the link to the application.

https://gallery.alteryx.com/#!app/Convert-ASCII-Grid-to-Alteryx/599b4abceffc2a09d400a82c

1. The input file typically has a .txt extension, but the app won't take that as input. The error I receive is this:

The job Convert ASCII Grid to Alteryx did not complete successfully and resulted in the following errors:

The Action "Tool #27" has an error: The file "In_599b4e33904d1c42914ec72b\larimer_colorado_dem_90m.txt" is not a known format. (2)

2. I can't successfully output the data as a .yxdb format file. I can output as a .shp format file. The error I receive is this:

The job Convert ASCII Grid to Alteryx did not complete successfully and resulted in the following errors:

Error creating the file " Z:\Service\Staging\2404_75b3c79993b74cffbb9f434afa51cc6f\test.yxdb|||Table1 ": The filename, directory name, or volume label syntax is incorrect. (Tool Id: 28)

Can someone help me figure out the causes and remedies for these two issues?

I've attached both the .csv and the .txt versions of an example data set for testing.

Re: Alteryx Gallery App input and output problems

patrick_digan — Tue, 22 Aug 2017 14:32:40 GMT

For #1, Alteryx has a cool feature whereby when you select a file with a known extension, Alteryx will automatically be able to read the file in. As you've come across, this causes problems when the filetype is not a known file type (txt is not a known filetype since we're reading it in a csv). In order to handle a txt file, I've made an adjustment in the attached: I added a condition tool and an action tool. The condition tool makes sure that just one action tool fires off. The action tool that I added will just replace the filename and not change the extension (which is what your original action tool is doing by default). This should allow you to read in all known file types (csv, flat, xls) plus txt.

As for #2, I would reach out to support@alteryx.com. Unless we're both missing something, I'm not sure why it's adding the table1 business to your yxdb. I tried assorted workarounds with no luck. I think you have it setup correctly. I'd be happy to hear I'm wrong and this one so that I can learn something new!

Re: Alteryx Gallery App input and output problems

Priyam — Wed, 20 Dec 2017 05:45:35 GMT

Hi Philip,

I am facing the same output issue that you mentioned in #2 and I get a similar error as shown in screen shot below. Were you able to resolve this please?

New Workflow1 12/20/2017 RE-RUN

Oops!
The job New Workflow1 did not complete successfully and resulted in the following errors:
- Error creating the file " D:\ProgramData\Alteryx\Service\Staging\11436_c5b330b3e7604c67809483f466c6e6d8\Test_Output.yxdb|||Table1 ": The filename, directory name, or volume label syntax is incorrect. (Tool Id: 8)

Re: Alteryx Gallery App input and output problems

rspear — Tue, 11 Sep 2018 22:39:23 GMT

Thank you! Works great. Really appreciate it!

Re: Alteryx Gallery App input and output problems

ajsmith — Thu, 30 May 2019 15:23:14 GMT

Did you resolve this issue in the end? I am now coming across it.

Re: Alteryx Gallery App input and output problems

calebdugger — Wed, 16 Oct 2019 17:49:42 GMT

Did anyone come up with a solution to this? I have the same problem where it adds a table to the end and I want it to be CSV

Re: Alteryx Gallery App input and output problems

jdylancampbell — Mon, 28 Oct 2019 17:05:51 GMT

Was there ever a solution found for #2? Currently facing this issue.

Re: Alteryx Gallery App input and output problems

calebdugger — Mon, 28 Oct 2019 18:17:29 GMT

Will it work if you change the Action Tool to "Update Value" instead of the default "Update Output Data Tool"? That's what worked for me in the end.

Re: Alteryx Gallery App input and output problems

Matt19 — Tue, 07 Mar 2023 17:21:37 GMT

Hey All,

Still running into this issue on Ver 2022.1, what I found interesting is that the default choice "Alteryx Database as Browse Everywhere" is where I run into the issue of Alteryx appending the "Table1" to the file path, but if I choose the regular "Alteryx Database" it seems to work as intended. Not sure if others can confirm a similar experience, but wanted to share!