Input tool issue

[satya04]

I have around 50 .xls files in a folder that are to be to brought in through input tool. All files start with OUTPUT_122023 and then followed by the file no. The rows and columns in the file are also the same.

Please guide me on how I can insert the file through input tool.

This is the error message that I am getting now.

[Qiu]

@satya04 
Are you using some special characters in your file name?

I know that alteryx can not import the sheet names of one .xls file but other than that, it should work.

[satya04]

@Qiu yes. I have underscore in the file name.

Output_12_12_2023_10000

Should this be changed? Please suggest.

[Qiu]

@satya04 
Underscore should be fine

Will you be able to share one sample input, which will cause error in your snapshot?

[flying008]

Hi, @satya04 

Maybe you can upload a sample data like xxx.xls file or snapshot like @Qiu , then we can help you.