Dynamic input issue not accepting files because different schema

[bui195]

I'm loading trial balance files for multiple months using Dynamic Input. There is one file in Excel format and the rest of them is CSV. I saved the Excel format into CSV and copy the headers from CSV over to Excel (now CSV) file but Alteryx still won't load the Excel file. Is there anything else I can do so Dynamic Input will accept the Excel (now CSV) file?

[alexnajm]

My guess is that you don't have a Sheet name for the single Excel file from the Directory tool. CSV files don't have multiple tabs but Excels theoretically can, so the sheet name is necessary for the Dynamic Input to work, and the Directory tool doesn't read in sheet names by default.

You can use a Formula to add in that sheet name (similar to the batch macro option here:The Ultimate Input Data Flowchart - Alteryx Community entrée de données eingabedaten) to just the Excel file row(s) and the Dynamic Input should work after that.