Import data from CSV failing to recognise dates leading to long processing time

[kityee11]

Hi,

I am trying to import data from a large CSV file (25GB). However it has failed to recognise all the date columns in date format. They were recognised as string instead.

To overcome this problem, I used a datetime tool to convert the dates from string to date format.  

However, this led to long processing time (30-35min). Is there a way to make the process more efficient to cut down import and conversion time?

Thanks, 

Kit Yee 

[messi007]

@kityee11,

I suggest you to replace the Date time parse tool with Formula tool using the datetimeparse function :

https://help.alteryx.com/20213/designer/datetime-functions 

Hope this helps!

Regards,