topic Thousand Separator in tFileExcelSheetOutput component in Talend Studio

Thousand Separator in tFileExcelSheetOutput component

mani1304 — Thu, 08 Aug 2019 08:22:53 GMT

Hi,

I want to know how can I have thousand separator in tFileExcelSheetOutput component, tFileOutputExcel component has this option but it's shrinking the length of header if I apply autofit, it shrinks on the basis of values in the column.

tFileExcelSheetOutput component working fine with header width, if I apply autofit, but here I am not getting how to apply thousand separator, although it has "Date or number format" in Column configuration.

It has 2 columns which are Bigdecimal, but these are showing in the excel having E like 123123123123123 showing as 1.23123E+14, please let me know how to correct this also.

Apart from this, can someone suggest, how can I learn about these custom components.

Re: Thousand Separator in tFileExcelSheetOutput component

Anonymous — Thu, 08 Aug 2019 15:28:03 GMT

Hi,

Could you please share your header and 5 sample input records for the problematic column?

Please also specify what is the expected value for those 5 records.

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: Thousand Separator in tFileExcelSheetOutput component

mani1304 — Fri, 09 Aug 2019 07:55:37 GMT

I got it, it should be as per the excel under the "".