Input

vijaylnyadav

Hi All,

I have a scenario,

I want to except a file from user using a interface.

User should have a independent of file format.

Please consider the following image as example.

For e.g,

User can choose any file format in a single interface which we are asking from user.

Please suggest some workflows.

Thanks

inoput.png

Datasets

Accepted answers

All comments

morr-co

Hi @vijaylnyadav - the advice I received from Alteryx is that the best way to build a macro is to first build a workflow that works, then convert it to a macro. In the example below, I configured the input tool to read a file on my local machine. When you connect the interface tool the default configuration is to "Update Input Data Tool". That should be all that you need.

Screen Shot 2021-01-07 at 9.18.41 AM.png

You can also limit the file selection to specific types in the File Browse tool:

Screen Shot 2021-01-07 at 9.19.14 AM.png

vijaylnyadav

@morr-co can you please build some workflow so that i can understand and implement it in my project as I am new to this tool

And as you mentioned I can limit the file selection to specify types can you explain this also with the help of workflow. It will be great help from your side.

CharlieS

Hi @vijaylnyadav

Are you looking to restrict the file type that a user input to the workflow? It looks like you're familiar with the File Browse tool from the interface category, so all that's left is customizing that tool and maybe adding a test afterwards.

File Browse Tool:

In the tool configuration, there's a setting to restrict the file type the user can select: The format of this string is a description and a RegEx-style match to the file name in this syntax:

Here's what this might look like if you only want the user to input .yxdb files:

Alteryx Database (*.yxdb)|*.yxdb

Now that we're armed with this understanding, we can extend this functionality to specify more that just file extension. Any part of the file name can be specified here: For example: I want the user to only input .yxdb file with "NEW" in the name. We can use "Alteryx NEW Database (*NEW*.yxdb)|*NEW*.yxdb"

Example workflow attached.

20210107-FileBrowseType.yxwz

vijaylnyadav

@CharlieSconsider i want the user should upload the input files in .txt, .dat, .xlsx, .xls, or .csv files that depends on the user.

Now with the file type as mentioned above can you please suggest workflow it will be a great help

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703