Cannot convert string to float - Sharepoint list

[craigja]

Not sure what else to do with this!  I cant see where the error is - I have a section that creates some output that goes to a SharePoint List, the existing bit works fine, no errors.  I've created a new section with the same fields and field types, if I union this with the current working section, I get the 'could not convert string to float' error, now the strange thing!  If I remove the union and just run in the new section, it works with no errors!  So basically, run in the old section, no errors, run in the new section, no errors, union them both together and I get 'could not convert string to float'  Any idea what to check?  I dont have a string field that needs converting and why do they work when not unioned?

[griffinwelsh]

@craigja Check the metadata of the fields leading into the union. This error means one of these fields is stored as a string and the other is stored as a numeric value. You can change the metadata with a select tool before the union tool.

[craigja]

I still get the same error and there are no string fields in the data im trying to submit!

[craigja · Accepted solution]

Sorted!  You cant insert a null into a number column