Replacing NULL values with Specific values

Hi, I have the following table

Appln No    Date
1            31/10/2020
2             ?
3            14/11/2020
4             ?

I want to replace the missing values with a constant date for eg 31/12/2020.


there’s a “Missing Value” node for that:

If your date column is a “date type”, you’ll probably need to convert it to string before and back to the appropriate date type afterwards, as the node can to my knowledge not handle native date types.



Thanks @qqilihq, that worked like a charm!!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.