Need suggestion for using File Browse Tool

Hey Folks,

Current Scenario:

I have used Input Data tool for manually locating the file(.txt files) before running the process.

Expected:

As the location of file may change every time I am planning to use File Browse Interface tool and pass that to the Input data tool.

I am confused with the configuration part, I have to make .txt file as a mandatory.

What changes should i need to make in Update Input tool and in the Input Data Tool.

If you attach any workflow it is much appreciated, I have done a small research and I didn't get any satisfactory answers....

Regards and Thank You...

Workflow

Input

Settings

Preparation

Interface Tools

Accepted answers

Adrian_T

Hi @GouthamVijay,

The error is telling us that the record 73 in the txt file you uploaded has more fields than the template txt file configured in the Input Data Tool.

Will you be expecting users to upload txt files of different schemas or are they all the same?

If the files are expected to have the same schema, make sure to change the directory in the Input Data Tool (currently configured as Sample Txt File 1) to point to one of your txt files of the same schema.
If files of different schema are expected, you would have to replace the Input Data Tool with a Batch Input Macro. You can find the step by step guide here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Files-with-Different-Field/ta-p/13370
All other configurations should stay the same.

If you are still facing issues after performing the above steps, do upload a copy of your workflow with the sample text files you are experimenting with.

All comments

Adrian_T

Hey @GouthamVijay,

I have attached a sample workflow. To limit input files as .txt, set the "Arbitrary File Specification" = .txt as shown below:

File Browse Configuration.yxzp

ChrisTX

@GouthamVijay will you deploy your workflow to an Alteryx Server?

I've read posts about Folder Browse / File Browse not working on the server. Not sure if this is old information, or if Browse works the same on the server.

Chris

GouthamVijay

Hey @Adrian_T

Thanks for the response...

The option you have chosen in the update value is "File value".......that is not been running in my case..I tried running the process from uploading one of the text file...

But i got the following error

Should I need to change any settings in the Update Value?

Adrian_T

Hi @GouthamVijay,

The error is telling us that the record 73 in the txt file you uploaded has more fields than the template txt file configured in the Input Data Tool.

Will you be expecting users to upload txt files of different schemas or are they all the same?

If the files are expected to have the same schema, make sure to change the directory in the Input Data Tool (currently configured as Sample Txt File 1) to point to one of your txt files of the same schema.
If files of different schema are expected, you would have to replace the Input Data Tool with a Batch Input Macro. You can find the step by step guide here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Files-with-Different-Field/ta-p/13370
All other configurations should stay the same.

If you are still facing issues after performing the above steps, do upload a copy of your workflow with the sample text files you are experimenting with.

GouthamVijay

Hey @Adrian_T

All the text files will be having same schema, but the directory may be completely different each time...

Because this process will be deployed into multiple systems, users may have the file at any location in their system...

So the current process may not be feasible for me...Do you have any other suggestions?

Please upload a sample which can run like that...so i can incorporate the same logic.....

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703