Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, there.
I have a question.
One filed of my table.csv is called Time. It looks like so.
I want to load 'Time' in two columns like this.
..
I dont know how to make '12/3/2015' to '12/03/2015'. I cant use Left() to select date, because the Byte length of date in my csv is not same.
may be one option :
DateField: LOAD *, Timestamp(Timestamp#(DateTimeField, 'MM/DD/YYYY hh:mm'), 'hh:mm') AS TimeStamp, Date(Date#(DateTimeField, 'MM/DD/YYYY hh:mm'), 'MM/DD/YYYY') AS DateStamp INLINE [ DateTimeField 12/3/2015 01:21 2/6/2014 00:23 3/11/2015 00:18 ];