Hello,

I'm having a question. It's not really a problem but i'm wondering if anyone knows if it's possible.

Now when talends gets a value that's too long for a string field, the records doesn't get inserted and Talend says column x is too long.

Right now I have always added a Reject flow to an excel file and this file is mailed to indicate the records.

Now for another customer he says that it isn't ok that the record isn't inserted several time until it gets resolved. So we have a scheduled run everyday, which means the record isn't inserted that day.

Is it possible to insert the record but take a left or something if it's too long, so all characters that's in the limit of the length of the string should be inserted.

Is this possible in Talend or would I have to do a left function on every string field for this?

Anyone have other ideas/solutions for this?

Regards,
Mario De Pauw