• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Having a problem with Boolean Datatype

#1 2012-05-31 17:07:44

sundaresanv
New member
Registered: 2012-05-27
Posts: 7

Having a problem with Boolean Datatype

Hi,

I am loading my table from SQL SERVER to oracle. I got a boolean field in my input table which is nullable. I map this field to target table as CHAR(1) in oracle. I face problem when the value from input table come as NULL. Can i use any talend function or any logic to convert this NULL values as character (for ex convertiong NULL to "k') . Please provide me your inputs.

Thanks
SUNDARESAN V

Offline

#2 2012-06-01 05:01:15

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Having a problem with Boolean Datatype

Hi

You might use the expression below.
row1.boolColumn == null?"k": row1.boolColumn.toString()

Regards,
Pedro


Only Paranoid Survive.

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Having a problem with Boolean Datatype

Board footer

Powered by FluxBB