Wednesday, 8 January 2014

Converting Types in tMap Component - Tips & Tricks

Checking whether the field is having null values or not. If it is null value print the NULL(nothing) , if it is NOT null then convert the type and display the filed in the output(output could be any database output table).
1) String to Integer
  Relational.ISNULL(row1.EmployeeID) == true ? null:Integer.parseInt(row1.EmployeeID)

2) String to Double
Relational.ISNULL(row1.Revenue)==true? null:Double.parseDouble(row1.Revenue)

3) String to Long
Relational.ISNULL(row1.Category_ID) == true ? null:Long.parseLong(row1.Category_ID)

4) String to Date
null:new SimpleDateFormat ("EEE mm/DD/yyyy").parse(row1.Date)   

5) Integer to Double
Relational.ISNULL(row1.NumberOfEmployees)==true? null:Double.parseDouble(Integer.toString(row1.NumberOfEmployees)) 
6) Integer to String

((new Integer( Integer(

This post will be up-datable one.