Skip to main content
Question

Troubleshooting DateTimeConvertor rejected output


Screenshot 2023-06-24 144730Screenshot 2023-06-24 144517I 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.

8 replies

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • June 24, 2023

Hi @marrysharif​ 

 

Could you share a example of your dataset?

 

Thanks in Advance,

Danilo


danilo_fme wrote:

Hi @marrysharif​ 

 

Could you share a example of your dataset?

 

Thanks in Advance,

Danilo

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?


danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • June 29, 2023
marrysharif wrote:

@danilo_fme​ any idea?

Hi @marrysharif​ How is your attributes?


danilo_fme wrote:

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?


danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • June 29, 2023
danilo_fme wrote:

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


danilo_fme wrote:

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.

image


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!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings