Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Error: Dynamic Input - The file "xxx" has a different schema than the 1st file

Highlighted
6 - Meteoroid

Good afternoon 1 have 4 spread sheets i tried to group them and convert to text but still getting the same errror.

 

If i bring in the sheets individually i am able to do a union no problem.

Not sure why i am getting this error

Highlighted
6 - Meteoroid

That might work for some people, but if you have dates in your Excel file it will reformat them as Excel's text string for numbers. So if you use this solution you need to be careful. 

Highlighted
5 - Atom

This is how I resolved it, for those like me who still were struggling:

1- do this macro in Excel VBA: 

Sub CheckRegex()


Dim RegEx As Object
Set RegEx = CreateObject("VBScript.RegExp")
RegEx.Global = True
RegEx.Pattern = "^[\x20-\x7F]+$"
For Each objCell In ActiveSheet.UsedRange.Cells
If RegEx.Replace(objCell.Value, "") = objCell.Value Then
objCell.Interior.ColorIndex = 3
Else
RegExCheck = 1
End If
Next
End Sub

 

2- run the macro on every sheet which was "rejected" by the Alteryx dinamyc tool

3- in Excel, filter by colour red, and identify all the cells that are giving wrong results and correct them to proper ASCII

4- format all sheets to "Text", using the Home-General-> Text (in my case i also had issues with IDs perhaps sometimes read like numbers)

5- save the excel and close

6- rerun in Alteryx. Now the schema is properly recognized across every tab

I hope this helps other people to save the 3 hours i wasted today. Nicoletta

Highlighted
6 - Meteoroid

Hi,

 

I appreciating the fact that you have had the same problem as me and explained it in language that I understand...none of the macro's I've found make any sense. I'm going to see if I can work out which value might be causing the issue.

Labels