I have an Excel dataset. I am translating two time attributes named "Occurred_time" and "Reported_time" with this format:%I:%M:%S%p to this format:%H:%M:%S.
Although it shows me the Preview Data, the result is rejected. I can't find what is the problem.
Oh yes, thank you.
I kept the required columns.
I have transformed the date columns with the same transformer and it worked.
@danilo_fme any idea?
Hi @marrysharif How is your attributes?
Hi @danilo_fme
I left that part for now because I can't find a solution. I shared a sample, an Excel. Have you seen it?
Hi @marrysharif How is your attributes?
I checked the file, but I didnt understand well.
The attribute Occurrence_Time is date format that you want %H:%M:%S
Hi @marrysharif How is your attributes?
Yes correct. both time columns. and both date columns in mm/dd/yyyy. and this is my workflow. the date converting worked but the time converting got rejected.
I created a sample file and typed the data into it and it worked! I don't know what's wrong with my original excel!