WARNING: * ... has a different schema than the 1st file in the set and will be skipped
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am attempting to process multiple Excel files (forms).
When using "Data Input," I receive multiple warnings stating, "... has a different schema than the first file in the set and will be skipped."
Is there a way to ignore these warnings so that the files are not skipped?
The differences between the files lie in the type and size of the strings.
- Labels:
- Datasets
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are these excel files or are they csv/text files. If its excel then specify a range thats greater than the largest spreadsheet eg Sheet1$A1:AZ. If its csv then import them as FLAT files specifying the character as say 1000 chars then use the Text To Columns function to split the data by the delimiter.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Another way would be to input it through a batch macro and change the Output mode in Interface Designer (Ctrl + Alt + D) to Auto Configure by Name (Wait until all iterations run)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This might help with the batch macro option! The Ultimate Input Data Flowchart - Alteryx Community entrée de données eingabedaten