Alteryx

Question

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

FrederikE · Answer

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.

flying008 · Answer

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.

ilovecoding · Answer

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.