I have the need to increment the seconds on a date/time field if an ID is the same. An example of the data would include
ID | DATE/TIME |
3 | 2015-06-03 00:00:00 |
3 | 2015-06-03 00:00:00 |
5 | 2014-01-15 00:00:00 |
5 | 2014-01-15 00:00:00 |
5 | 2014-01-15 00:00:00 |
The end result I'm looking for is...
ID | DATE/TIME |
3 | 2015-06-03 00:00:00 |
3 | 2015-06-03 00:00:01 |
5 | 2014-01-15 00:00:00 |
5 | 2014-01-15 00:00:01 |
5 | 2014-01-15 00:00:02 |
I figured I would use the multi-row tool where I could group by the ID and then use an expression to add the increment. However I cannot figure out the format of the expression I should use.
Solved! Go to Solution.
Hi @G_WOLAK
You could use the Tile Tool for that.
Tile Tool with Unique Method on ID.
Use Formula Tool to add the seconds - DateTimeAdd([DATE/TIME],[Tile_SequenceNum] - 1, "seconds")
WF attached.
Cheers,
Absolutely fantastic! That did it. Thanks!
Hi @G_WOLAK,
Just to show you there is also always more than one way to solve a problem this is the multi row formula route you were talking about taking. I've attached the workbook for you to download if needed.
If this solves your issue please mark the answer as correct, if not let me know!
Regards,
Jonathan
That too also worked. Glad to know I had the right idea in mind. Good to know there are two ways to go about this.
Thanks!