Replace "0" (Number) with NULL in Pentaho Data Integration

Question

How do I replace a specific value (Number or Integer) with NULL?

I ve got a number field containing "0" and I need to replace it with NULL (empty). How do I do it with a Pentaho Data Integration step? I dont want to use javascript.

score 2 · Accepted Answer · answered Feb 19 '19 at 15:44

2

In your Transformation Steps dropdown menu > Utility, "Null if..." Step. Select the Field you want to transform and under the tab Value to turn to NULL you use "0"

answered Feb 19 '19 at 15:44

Cristian Curti

1,004
1
7
13

Replace "0" (Number) with NULL in Pentaho Data Integration

1 Answers1