Date Comparison Function
A Date Comparison Node helps getting the difference between two dates or date time, by comparing a selected column with another, or comparing it with a constant; returning a result either as seconds, minutes, hours, days, months or years. Here’s a guide on how to add and set up a Date Comparison Node:
Setting Up your Date Comparison Node
Note: In order to use the Model feature you already should have already imported data sources into Y42.
Adding the Date Comparison Node to your Model
- Select Model on the right of your window and click Add Model. Name your new Model and choose a privacy level.
- Create at least one input table by dragging & dropping the Input field into your data model structure. Choose a data table by clicking on it, then click Save.
- Drag & drop a Date Comparison Node close to the Input field.
Setting Up your Date Comparison Node
- Click on the Date Comparison Node to apply the settings.
- Begin by selecting the Target Column or write the name of a new column.
- Then choosing the unit the new columns with be in, e.g. seconds, hours...
- Select a Source Column,
- Add its comparison, be it a Constant or Existing Column + Select includes +/- if you want the difference to not be in absolute values.
- Select the Comparison Column.
- When you are done, press Save.
Once you're done comparing the date and date time of columns, you can either perform further transformations or, if you want to export the new data table, click Commit Model.
Was this article helpful?