We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Connecting to Text File

Hi Team,

 

I am new to Alteryx.  

 

Requirement:

  • I need to connect to Box server
  • Access text file with Pipe delimiter.
  • Process this file.

Created workflow:

  • Box input tool
  • Connected to my Box server.
  • in the configuration, there's no option to select text file. Only options I can see are CSV, XLSX and YXDB.
  • I had selected CSV with pipe delimiter.

When executed, I am getting error: Error: Box Input (2): Extension field does not match with file extension. Please enter valid extension.

 

Could anyone of you please help on how I can resolve this issue.

3 REPLIES 3
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

Hi, @SunithaBalemarthi ,

 

I do not use box, but the error message says the extension is not valid.

So I guess the extension ".txt" is the problem in your case.

 

According to https://help.alteryx.com/20231/designer/box-input-tool , it says;

9. If you want to process a file of a file type that Box Input doesn’t support or if you want to keep an offline copy of a file,

select Download file locally for later processing and choose the location to save the file.

The default location is %TEMP%.

 

So you may want to try downloading the .txt file locally and process it later.

I hope it may be of some help. Good luck.

Thank you for replying. I had tried to download the file to my local machine, still the process is failing with the same error, attaching the screenshot for your reference.

 

Could you please take a look and let me know if I am doing something wrong.

Yoshiro_Fujimori
15 - Aurora
15 - Aurora

Hi @SunithaBalemarthi ,

 

As the document says the tool allows the user to process a file of a file type that Box Input doesn’t support,

if it still causes error, that can be a product issue.

So I would recommend you to get support from https://my.alteryx.com.

Labels
Top Solution Authors