2 Replies Latest reply: Apr 3, 2014 4:53 PM by Traci Dukes RSS

    Read excel -unable to convert value from type string to type double

      I am using the read excel operator for the first time.  I am getting the error "unable to convert value from type string to type double" no matter what I do to the schema.

      The issue arises when the postal code is ddddd-dddd.  I have changed the schema to a string and even tried deleting the mapping.

      First I tried to use the allow values in the constraints and error corrections dialog and that didn't work either.

       

      Any ideas would be helpful.  For now I am rejecting those records but need to get this fixed.  Otherwise .csv works fine but it would be great to not have to open and save the file to process if at all possible.

       

      Thanks Traci