Schema Mismatch Error in Input Files

[Dhilip_Kumar]

Hi All,

I am encountering an issue while using multiple input files with the same headers but different data types for some fields. Specifically, the Employee ID field has a "Double" data type in one file and a "V_String" data type in another/ This is causing the following error:

Error Message: 

"Warning: Input Data (1): The file "\Sample Test 2.xlsx|||`Sheet1$`" has a different schema than the 1st file in the set and will be skipped"

I have attached my input files and workflow for reference. Please advise on how to handle this schema mismatch and ensure all diles are processed correctly. This is an example file sometimes the folder contains 50+ files.

[ScottLewis]

This sounds like a job for a Batch Macro.

Referring to an article on deciding which version of input to use to get you started: Article