How to convert null values to any numeric value


In the above picture, Order column is from different table than the other columns. I have joined the two tables using Stream Lookup. I want to put ‘0’ in place of null value. I used two different approaches: filter rows plugin and modified java script but did not get satisfied result. Kindly help.

For the order column you could use a CASE statement with condition - column for NOT NULL and ELSE provide the value 0.

CASE
  WHEN (order IS NOT NULL)  THEN order
   ELSE 0
 END

Hi Vishakha,

You can use ‘If field value is null’ plugin in process studio. Select the checkbox ‘select field’ followed by click on get fields and select those fields in which you want to replace null values with value ‘0’.

Thanks, Suraj

Thank you Seema for your help.

Thank You Suraj for your help. I got the expected results.