Error : "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 keep getting the following error when reading a half dozen small Excel workbooks using a Data Input tool set to read *.xlsx from a specific folder. I have checked the Excel worksheets for format differences (header/footer, column headers, hidden columns, etc) and cannot find what is different if anything. I have even entered the scores from one survey response worksheet to the one that works and renamed/saved - still to no avail. I'm am definitely pulling my hair out over this one.
Anyone seen something weird like this occur before? Thoughts about how to troubleshoot? I have to process a fairly large number of worksheets in te next day or so. Open to any and all ideas... Thanks.
Warning: Input Data (1): The file "C:\Users\dennispuls\Desktop\Working Documents\XXX\CapMat Survey\XX Cap Mat Responses\R2 - 03.21.2019 - XX IT Capability Maturity Survey_XXX|||`Survey$`" has a different schema than the 1st file in the set and will be skipped
Solved! Go to Solution.
- Labels:
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The schema also looks for changes in field type/size, not just name. That is typically the source of the error you posted. To avoid this error, you could build a batch macro where the control parameter updates an Input tool, rather than using a Dynamic Input tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
**********************************************************************
The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter.
***********************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You could use 2 input data tools loading the 1st file and you file in question and then attach a field info tool to each to compare the fields and datatypes of both. If it's too difficult to compare visually, you can use a join tool to highlight the differences.
This is only if you have a burning curiosity to find the difference. Otherwise, the batch macro route that @CharlieS suggested is the way to go.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I've found that blank columns are defined as doubles by Alteryx. When I put text into them they revert to v_string 255. Blank them out, and back to doubles. Not sure why yet
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for this suggestion DavidP. Helped me find where dates were reading as double!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I experienced this same error with .csv files and was able to resolve it by changing the encoding on the input settings. Hope this helps.
SB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Would you be able to expand on what you did you resolve this?
I'm receiving this error but only on some of the rows that are being processed (I don't have the tool configured to fail when one row doesn't work)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This worked for me - I swticed to UTF-8 and am no longer getting the error. Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You are very welcome!! Glad it was able to help you!
