topic Re: tfileInputExcel dividing the % sign value automatically in Talend Studio

tfileInputExcel dividing the % sign value automatically

rk2019 — Sat, 16 Nov 2024 03:36:11 GMT

Hi Team,

Need to process s3 excel file and load into Redshift but excel file when processed through tfileInputExcel dividing the % sign value automatically which changes the decimal scale value like 99.997% to 0.99997 and so on in float data type. Is there anyway to read this excel file and turning into csv without any changes.

Re: tfileInputExcel dividing the % sign value automatically

Anonymous — Mon, 13 Jan 2020 22:56:21 GMT

Hi,

Please read it as a string and replace the % symbol using replace function in tMap.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: tfileInputExcel dividing the % sign value automatically

rk2019 — Tue, 14 Jan 2020 11:14:58 GMT

Hi Nikhil,

I am reading it as string only defining these columns in metadata as string data type , still it changing the value to multi scale decimal value like 0.970929 for

97.093%

Please help .

Re: tfileInputExcel dividing the % sign value automatically

Anonymous — Wed, 15 Jan 2020 00:43:50 GMT

Hi,

Could you please share the current job screenshot and the component details where it is getting converted?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved