Skip to main content
  • EN

I'm doing a change detection on a date field from 2 sources. One source always includes time even if they are "000000". The other source appears to be strip those 0's. How can I add the hours minutes seconds to the records that are missing them? Do I need to filter for the records missing time values before adding the 0's. I will attach an image with the "J_NotifyDate" column missing time if they are 0's

image

So you are wanting to make all null values in the J_CompleteDate field = "000000"? If so, the NullAttributeMapper transformer will be helpful to you.

Thanks I think that will work!

image

Reply


Community Stats

30,168
Posts
114,526
Replies
37,824
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.