I have a column call logon time, the data format is as below.
Logon Time
24/07/2015 01:12
24/07/2015 01:17
24/07/2015 01:17
24/07/2015 01:26
24/07/2015 01:26
24/07/2015 01:35
Thus, I set the load description below in data load editor.
SET TimestampFormat='DD/MM/YYYY hh:mm';
Then, it generates the year/month by the auto calendar script. However, no data is available when I try to drop a selection box. I think no data can be transform.