Merge Date and Time in Tall Tables

Hi there, I have a large csv file (555MB, 11.1m rows) which cannot be loaded into memory so that I'm utilising tall tables functionality. The file is 1 minute date with separate fields for Date and Time. I have successfully updated the Date and Time fields using the datetime function. However I have been unsuccessful in creating a new field that merges the date and time fields. I have experimented with the cat function as the strcat function is not available.

Answer 1

[George]

Try adding them together. Examples.