tfileInputExcel dividing the % sign value automatically

[rk2019]

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.

[Anonymous]

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

[rk2019]

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 .

[Anonymous]

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