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

Highlighted
Seven Stars

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

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.)

 

image.pngcode.PNGThose 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!


Accepted Solutions
Seven Stars

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

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

View solution in original post


All Replies
Community Manager

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

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.

Seven Stars

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

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

View solution in original post

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog