tfileInputExcel dividing the % sign value automatically
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.
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
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
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
