1 field in 2 columns Load?

tomcatxx — Thu, 26 Apr 2018 10:15:55 GMT

Hello, there.

I have a question.

One filed of my table.csv is called Time. It looks like so.

Time
12/3/2015 01:21
2/6/2014 00:23
3/11/2015 00:18
...
...
...

I want to load 'Time' in two columns like this.

date	time
12/03/2015	01:21
02/06/2014	00:23
03/11/2015	00:18
...	...
...	...
..	...

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.

Re: 1 field in 2 columns Load?

vishsaggi — Thu, 26 Apr 2018 15:38:47 GMT

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
];

topic 1 field in 2 columns Load? in QlikView

1 field in 2 columns Load?

Re: 1 field in 2 columns Load?