Thread: Create Timestamp and append it with existing input date field

I have to derive the timestamp value and append it to the existing date field and populate it in the target output file. This should be unique for every id field & col3.

My Input:

id line col1 col2 col3(mmddyyyy)
1 1 abc 123 01012018
1 2 cba 432 01012018
1 3 xyz 463 01012018
2 1 tew 321 02012018
2 2 abc 422 02012018
3 1 tef 001 10052018
4 1 hrg 963 03202018

For the above given sample data the target output field should be populated with timestamp attached. For every time mapping run the Hour(HH) value should be starting from 09 AM.

Expected Output:

Target output Field Format - MMDDYYYYHHMMSSmmm Where MMDDYYY - col3

HH (Hour) - Should always start from 09 MM (Minute) - start value 00 and max value 60 (Increment hour by 1 when it reaches 60 and reset this to '00')

SS (Seconds) - start value 00 and max value 60 (Increment Minute by 1 when it reaches 60 and reset this to '00')

mmm (milliseconds) - start value 000 and max value 999 (Increment seconds by 1 when it reaches 999 and reset this to '000')

Please do let me know if need any additional informations on my question.