Five Stars

Special Character issue in Talend

Hi ,

 

 I developed a job in talend which loads data into specific tables from excel and excel has some % values in it.But while loading the data into it DB, if data has special characters (%,- )in some field like Amount  , the actual amount is converting to zero.Could you please help how to solve this?

2 REPLIES
Thirteen Stars TRF
Thirteen Stars

Re: Special Character issue in Talend

Hi,
Seems these fields are string datatype (else, how can they contain something else than digits?)
What is the datatype on database side?
Do you have any before insert trigger for the target table?

TRF
Six Stars

Re: Special Character issue in Talend

Can you confirm the excel-sheet and DB table data type for these amount and actual amount fields?

In general if you have string data type for excel and in DB you are using nvarchar, it will not show any zero amount or blank value.


Regards,
Mohit