Hi,
while preparing an example workflow I noticed that the capabilities to modify a duration column, both Duration Date-/ and Time-based, are quite limited. I.e. the Time Shifter states to generally “Shifts time columns by a defined duration or granularity.“
But it doesn’t even recognize the two column types:
The Duration (Time-based) to Number node only covnerts to long type despite Integer being set as output mode, which is difficult to work with too.
I’d like to propose to create a node that:
- Ingests both duration / period based types Duration Date-/ and Time-based
- Allows to chose between int and long
- Add an option to return missing if int is chosen but long being requried
- Add an option to warn instead of error out in case of int vs. long
Also adding a duration / period shift node respectively extending the Time Shifter node.
Best
Mike