topic Re: [resolved] data trim column while delete in Talend Studio

[resolved] data trim column while delete

djugal — Fri, 18 May 2012 08:05:33 GMT

Hii,
I have a job in which while taking the input from mysql i check the option of trim all string/char columns.
i have a mysql output component where delete is option.
my prob is i have trimmed all the cols so my key column for delete is also trimmed
now when i delete records the key value doesnt match as it has been trimmed.
i can do it by not trimming key column in the input but is there any other workaround for this.
regards,
djugal

Re: [resolved] data trim column while delete

Anonymous — Fri, 18 May 2012 08:21:06 GMT

Hi Djugal
Not trimming key column is the most convenient way.
Regards,
Pedro

Re: [resolved] data trim column while delete

djugal — Fri, 18 May 2012 10:04:18 GMT

ok thanks,
just curious, if additional columns in additional settings of mysqloutput could be of any help.
regards,
djugal

Re: [resolved] data trim column while delete

janhess — Fri, 18 May 2012 10:14:28 GMT

Why would you want to trim it?

Re: [resolved] data trim column while delete

Anonymous — Fri, 18 May 2012 10:17:44 GMT

Hi Djugal
The Additional columns option allows you to call sql functions to perform actions on columns.
In my opinion, it is not appropriate here.
Regards,
Pedro

Re: [resolved] data trim column while delete

djugal — Fri, 18 May 2012 10:33:04 GMT

@janhess - i want to trim all columns as i am inserting some acceptable data as well as rejecting data which dont meet criteria, all my reject rows are fed to dboutput where rows r deleted, all accepted cols are fed into another dboutput where they are inserted which has to be in trimmed format
@pedro - thanks
regards,
djugal

Re: [resolved] data trim column while delete

janhess — Fri, 18 May 2012 10:59:54 GMT

I've found in those circumstances it is best to do the delete first without any trimming, then do the insert/update using trimming in a second process.

Re: [resolved] data trim column while delete

djugal — Fri, 18 May 2012 11:06:47 GMT

k will try tht thks janhess