Connecting to Text File

Question

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.

Yoshiro_Fujimori · Answer

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.

SunithaBalemarthi · Answer

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.

Screenshot 2023-10-09 150928.jpg

Yoshiro_Fujimori · Answer

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.