Featured Post

Applying Email Validation to a JavaFX TextField Using Binding

This example uses the same controller as in a previous post but adds a use case to support email validation.  A Commons Validator object is ...

Saturday, February 5, 2011

[TUTORIAL] Converting Data Types with Talend Open Studio

Use tConvertType's Auto Cast to convert a batch of String fields to a more restrictive data type like Long.

Posted by at

12 comments:

  1. AnonymousFebruary 18, 2013 at 4:50 AM

    Can i use tConvertType to convert Time to String??

    ReplyDelete
    Replies
    1. CarlFebruary 18, 2013 at 7:59 AM

      Hi,

      Use a tMap with the Routine TalendDate.formatDate (String->Date) or Talenddate.parseDate (Date->String).

      For example, add this to a target field in a tMap

      TalendDate.formatDate("yyyy-MM-dd HH:mm:ss",row1.today_d )

      tConvertType is used for conversions between String, Double, Float, Long, Short, and Integer.

      Delete
    2. AnonymousFebruary 22, 2013 at 4:21 AM

      I manage to convert time to string (with tConvert)and back to time (in tMap)with this other row: Talenddate.parseDate("HH:mm:ss",row1.today_d)
      Thanks for replying :)

      Delete
  2. Sonia HamiltonSeptember 19, 2013 at 1:19 AM

    Thanks, nice post :-)

    Unfortunately I found a bug in tConvertType - https://jira.talendforge.org/browse/TDI-27516

    The tConvertType is unable to convert a string like "4,096" to an integer. When piping "Row, Rejects" to a .csv file I get errors like:

    "Memory:For input string: "4,096";Provisioned_MB:For input string: "55,297"

    ReplyDelete
  3. AnonymousApril 17, 2015 at 8:19 AM

    how to convert Bigdecimal to integer in talend????

    ReplyDelete
  4. AnonymousJanuary 21, 2016 at 10:13 AM

    Use the Bigdecimal's method intValueExact()

    ReplyDelete
  5. UnknownOctober 7, 2016 at 3:21 AM

    without tconverter how to change the datatype in talend

    ReplyDelete
  6. UnknownOctober 7, 2016 at 3:35 AM

    without tconverter how to change the datatype in talend

    ReplyDelete
    Replies
    1. CarlOctober 7, 2016 at 6:30 AM

      Use a tMap or tJavaRow, putting a Java expression in for the conversion.

      Good luck

      Delete
  7. ombalakumarJune 9, 2017 at 6:14 AM

    How to convert Data type Dynamic to String and String to Dynamic in talend

    ReplyDelete
  8. AnonymousJanuary 18, 2019 at 7:49 PM

    i have question can we convert number date to date format using tConverType component

    my incoming integer date is "01182019"

    ReplyDelete
  9. UnknownMarch 25, 2019 at 8:47 AM

    I need to convert a vlaue from bigdecimal to float i can?

    ReplyDelete

Subscribe to: Post Comments (Atom)