topic Re: Stringhandling.trim on column is not working in Tmap. in Talend Studio

Stringhandling.trim on column is not working in Tmap.

Anonymous — Wed, 13 Nov 2019 08:49:49 GMT

Hi Team,

We are facing issue with spaces in column and when we are trimming it in Tmap before loading into table then, we are still unable to fetch data due to whitespace and when we used SQL command in Postjob to trim the column then, it perform well without any issue as below.

Our source and target is Database as Postgres.

update vmrctta1.vmrraccnt_part_extrt_stg set accnt_cntry_cd=trim(accnt_cntry_cd);

Please suggest what will be the reason.

Re: Stringhandling.trim on column is not working in Tmap.

manodwhb — Wed, 13 Nov 2019 08:57:17 GMT

@rohitatcs , you need to re write a query below way

UPDATE t
SET t.accnt_cntry_cd= trim(t2.accnt_cntry_cd)
FROM vmrctta1.vmrraccnt_part_extrt_stg t
INNER JOIN vmrctta1.vmrraccnt_part_extrt_stgt2 ON t.Id = t2.Id

Re: Stringhandling.trim on column is not working in Tmap.

Anonymous — Wed, 13 Nov 2019 10:45:10 GMT

Thanks for your reply.

The query is anyway working fine.

My question is trim in tmap is not able to trim the column whitespace however, SQL query is working for us.

Re: Stringhandling.trim on column is not working in Tmap.

Anonymous — Mon, 18 Nov 2019 12:00:37 GMT

Team,

Please suggest why source level trim in advanced setting is not working and when we manually do type Update statement in Postgresqlrow component then it work. Please suggest as all our table having issue and it will be hard to add Postgreslrow component and add SQL command for trim in each Job.