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. larimer_colorado_dem_90m.csv larimer_colorado_dem_90m.txt

Alteryx Gallery App input and output problems

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.

larimer_colorado_dem_90m.csv

larimer_colorado_dem_90m.txt

Gallery

Apps

Interface Tools

Accepted answers

patrick_digan

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!

Convert ASCII Grid to Alteryx.yxzp

All comments

patrick_digan

Convert ASCII Grid to Alteryx.yxzp

Priyam

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 " \ProgramData\Alteryx\Service\Staging\11436_c5b330b3e7604c67809483f466c6e6d8\Test_Output.yxdb|||Table1 ": The filename, directory name, or volume label syntax is incorrect. (Tool Id: 8)

rspear

Thank you! Works great. Really appreciate it!

ajsmith

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

jdylancampbell

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

calebdugger

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.

Matt19

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!

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335