Input file browse can accept multiple file format

[vijaylnyadav]

@Qiu, @christine_assaad  and @Morgan_Thomas. please comment on this.

If I use file browse and input folder in a interface designer

I am using 5 file browse.

Refer this solution: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Optional-Input-Folder-Browse-using-rad...

Condition:

The user can upload file with format

1 .xlsx, with sheet name

2 .xls, with sheet name

3 .csv with with sheet name and  '|' delimiter,

4 .txt with | delimiter

5 .dat with | delimiter.

But how to design a solution.

because I am getting an error of unknown file format.

I want that a single file can accept all these 5 file format.

If i am uploading xls file format than error is that "Please choose a table".

I want that the user can choose the sheet names also for xls, xlsx and csv with | delimiter.

Please help me on this. 

Please suggest some workflow

Thanks.

[TrevorS]

Hello @vijaylnyadav 

You will likely want to consider using a batch macro for this as you will need to have an input option for each file type which is updated based on what is selected.

I would recommend getting started with the below posts!

https://community.alteryx.com/t5/Interactive-Lessons/Creating-a-Batch-Macro/ta-p/657923

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/t...

Thanks,
TrevorS