Hi, I am struggling with the time format of a field. I have a .csv file with a field with datetime information
For example,
However, when I connect it to alteryx it looks like this
Do you know why is this happening?
Thank you!
Simplest way I can think of is regex parse:
(\d{1,2}/\d{1,2}/\d{4})\s(\d{2}:\d{2})(:\d{2}:)*\s([a-z]{2})
That should split it up into the major pieces and you can add in the :00 to the second group.
I am referring to :00 PM that is missing
Hi @OrlanViloria
On initial glance, it could be a field length issue. Not sure if this will work, but drop a Select tool after the input, and change the length of that field to longer.
Let me know if that works.
Cheers!
Esther
Hi! I am trying with this configuration
However, it did not fixed the problem
