Replacing NULL values with Specific values

[abishaymathewd]

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.

[qqilihq]

Hi,

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

Missing Value — NodePit

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.

–P

[abishaymathewd]

Thanks @qqilihq, that worked like a charm!!