How do I replace a number (like 0) with NULL in PDI 8.2. I was thinking something like Replace in String. I would like to not do it with a Java Script step if possible. Thanks! <a data-tag-text="Kettle" data-sign="#" class="user-content-hashtag" href="https://hitachi.connectedcommunity.org/search?s=tags%3A%22Kettle%22&executesearch=true" data-tag-key="e58f5353-0c00-4c3e-854c-4b082a5ea7b6">#Kettle</a> <a data-tag-text="PentahoDataIntegrationPDI" data-sign="#" class="user-content-hashtag" href="https://hitachi.connectedcommunity.org/search?s=tags%3A%22Pentaho Data Integration PDI%22&executesearch=true" data-tag-key="b01e3d75-3411-4f9a-a674-a7e8d0c9c995">#PentahoDataIntegrationPDI</a> <a data-tag-text="Pentaho" data-sign="#" class="user-content-hashtag" href="https://hitachi.connectedcommunity.org/search?s=tags%3A%22Pentaho%22&executesearch=true" data-tag-key="70b4436b-4549-4ce3-aa64-4566c7b665c9">#Pentaho</a>

Pentaho

View Only

Dirk Sachse posted 02-19-2019 13:00

How do I replace a number (like 0) with NULL in PDI 8.2.

I was thinking something like Replace in String. I would like to not do it with a Java Script step if possible.

Thanks!

Ravikumar Kamma posted 02-19-2019 14:29

use "Null if" step

~Ravik