In the Transform Map, does "Coalesce empty fields" apply to Timestamps?

[Derek Sewall]

I'm importing data from multiple sources using transform maps. The data includes a timestamp (HH:mm:ss) of the incident. Some of the records have missing timestamps, but there is enough data within the records to know that they should be coalesced. However, when I select "Coalesce empty fields" on the field transformations for the timestamp values, I'm still seeing multiple records, so the records aren't coalescing as expected.

Are there field type limitations for the "Coalesce empty fields" option? What else would prevent two records with NULL coalesce values from coalescing, provided every other coalesce field is an exact match?

[AnubhavRitolia]

Instead of using Coalesce Empty field of Time Stamp field, Better use Either Script on Transform Map or use before Transform Script to check the value of Time Stamp Field and if you don't want it to be important than put 'ignore=true'.

Please mark this as correct answer if it resolved, or mark this helpful if this help you to reach towards solution.

[Derek Sewall]

Thanks Anubhav. So to clarify, you're saying that the "Coalesce on empty field" option does not work on timestamps?

How would the before Transform Script work in this scenario? Are you suggesting that the script would only set "coalesce" to "true" if the timestamp is NULL? Would that work if I only wanted to coalesce with a target record if it also has a NULL timestamp?