@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.
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
Thanks,
TrevorS