Replace null value with NA using Pentaho Kettle

pentaho kettle data-integration pentaho-spoon
Lavanya D. picture Lavanya D. · Mar 30, 2016 · Viewed 10.5k times · Source

I have an input csv file with one column field value as empty. I want to replace that field value as NA in my destination table. And in my destination table that column is specified as not null column.

I tried using if field value is null, value mapper step. but it doesnt work out.. can anyone suggest how to proceed.

Answer

Marlon Abeykoon picture Marlon Abeykoon · Mar 30, 2016

The NULLS can not be replaced using If field value is null step if you enable Lazy Conversion in CSV input step.

So untick the lazy conversion? check box in CSV Input step. Then in If field value is null step check Select fields check box and select the field you want to check nulls and type NA in Replace by value column.

Related questions

Use JSON Input step to process uneven data

I'm trying to process the following with an JSON Input step: {"address":[ {"AddressId":"1_1","Street":"A Street"}, {"AddressId":"1_101","Street":"Another Street"}, {"AddressId":"1_102","Street":"One more street", "Locality":"Buenos Aires"}, {"AddressId":"1_102","Locality":"New York"} ]} However this seems not to be possible: Json …

Read More
Changing a field from String to Int in Pentaho Data Integration

I am taking JSON information from our online API and producing it in a table with DI. I have 4 fields url, deviceId, displacement & timestamp. These are all recorded as Strings but I want them to be Int values, bar …

Read More
pentaho kettle : get row count from stream

I would like to get the total record count from the get rows from result output and then pass it to parent job. Any suggestions ?

Read More