I setup a generic template because the excel files do not have a consistent schema. This is the template
which is interpreted as text
![Capture3.JPG Capture3.JPG](https://community.alteryx.com/t5/image/serverpage/image-id/7298i9CC739BACD526676/image-size/large?v=v2&px=999)
When I feed files into the dynamic input tool the output configuration is
![Capture2.JPG Capture2.JPG](https://community.alteryx.com/t5/image/serverpage/image-id/7299i547F0A6EC71204F5/image-size/large?v=v2&px=999)
This is the schema of the first file read by the DI tool. Why didn't it use the template?
The requirement to have all the schemas match is difficult - especially with excel.
I would like to suggest the input tool have a checkbox to override the data driver and interpret all columns as text.
Read excel as text
https://www.connectionstrings.com/ace-oledb-12-0/treating-data-as-text/