topic Handling number columns in Talend in Talend Studio

Handling number columns in Talend

xx_emanis — Sat, 16 Nov 2024 07:18:37 GMT

Hi All,

I am loading CSV file to a table in Snowflake database. I have one column with numerical values. How to handle this kind of numbers while loading to target table.

2.90587E+11 is one of the value I have in the CSV file. When clicked on this in excel, this is the number I am seeing and that is what is to be loaded to target.

2.90587E+11 ------------------> 290587467776

Thank You

Re: Handling number columns in Talend

ankit7359 — Wed, 14 Nov 2018 03:50:48 GMT

Hi,

Greetings of the day,

I see u r tryin to load a number value into the target...

well u will see in excel as an E...

so for this u must change the datatype of the column.

for example considering this column as Abc... number is the default datatype... change the datatype in the tfileinputdelimited to long... such that it can take this huge number and convert them.

however there is another method where you can cast it....Casting(changing of datatype from one to another)

in tmap u can cast..it... If you would notice for row1.data on the out1..... u can cast it to long by writing this method..... -> row1.anynumbercolumn.longvalue()

Re: Handling number columns in Talend

Anonymous — Wed, 14 Nov 2018 05:56:18 GMT

Hi,

Excel will auto format the values for display. I would suggest to open the file using a normal text editor like notepad++ which will show the actual value. Based on your requirement, you can read this value in original format from the file using Talend and pass it to Snowflake.

Warm Regards,

Nikhil Thampi

Re: Handling number columns in Talend

Anonymous — Wed, 14 Nov 2018 17:06:02 GMT

@xx_emanis

I hope the details helped you to resolve the issue. Could you please confirm?

If the reply has helped you, could you please mark the topic as resolved so that it will help our fellow Talend community members for future reference? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: Handling number columns in Talend

xx_emanis — Wed, 14 Nov 2018 17:07:59 GMT

Thank you. This helped me achieve my requirement.