I need to fix this asap help please : cannot convert from char to string

[Anonymous]

I'm having this error, while I'm trying to load a csv file, with a field separator  '|'. The data is from table with identical structure on where I'm trying to load it. ( ALL ARE THE SAME, ccolumn name, data types, description, etc.)

Y if conditions meet, For A value from A -> C or M if conditions meet">Those are the default value of the column in the table design and it will change from N -> Y if conditions meet, For A value from A -> C or M if conditions meet

Thanks for any help!

[Anonymous]

It looks like your column (not sure which one as you have blackened it out) is a String and you are assigning 'A' and 'N'. Literal values in single quotes are chars and double quotes are Strings. Either change your column to a Char or your literal values to Strings.

[Anonymous · Accepted solution]

Thanks for the response. I already fixed it and working perfectly now. Thanks