Hi Champs,
While doing lookup I'm able to get the column from a different file using the Join function, the column is in DATE TIME (including sec and AM/PM) format but in the output, it is only picking date and time (hours and mins). Seconds and AM/PM are missing out from the output.
Can someone assist here, please?
Thanks in advance
Hi,@ilovecoding
maybe you can post a table data before join, and a picture after join, then we can get idea.
Hi, Thanks for the quick response. I cannot post that as it is on my work interface. But to simplify, let me know if the below helps
Before the join column value is
05/10/2022 10:08:00 AM
After the Join column value is
05/10/2022 10:08
So, ":00 AM" is missing out on my output.
Hi,@ilovecoding
I assume the field name is [Date], and you cell value is "05/10/2022 10:08:00 AM" , but the field type maybe isn't a valid datetime format, do you sure? in Alteryx, the datetime format like "05/10/2022 10:08:00" .
and if the field type or length is change then the ":00 AM" is miss.
I have two Ideas how you could possibly solve the problem:
1. Check the size of the field, maybe it's too short.
2. Workaround: Join it as a string and transform it into "date time" after the join.