Stringhandling.trim on column is not working in Tmap.

[Anonymous]

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.

[manodwhb]

@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

[Anonymous]

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.

[Anonymous]

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.