Handling number columns in Talend

[xx_emanis]

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

[ankit7359]

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()

[Anonymous · Accepted solution]

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

[Anonymous]

@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

[xx_emanis]

Thank you. This helped me achieve my requirement.