Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I've a test file which contains the data as show below without any column name
05/04/2012 16:05:40 , 48
05/04/2012 16:13:40 , 256
05/04/2012 16:17:47 , 192
05/04/2012 16:26:18 , 431
05/04/2012 16:32:15 , 833
05/04/2012 16:40:29 , 369
05/04/2012 16:49:10 , 748
05/04/2012 16:51:10 , 467
05/17/2012 21:45:01 , 335
05/17/2012 21:51:11 , 457
05/17/2012 21:55:25 , 394
05/17/2012 22:00:59 , 446
05/17/2012 22:05:43 , 449
05/17/2012 22:09:53 , 242
- It i load the data in my qvw file the script is as shown below. I'm trying to get only dates from this but i can't get it exactly. I can able to see single wrong date only.
Main:
LOAD Date(@1,'M/D/YYYY') as TempDate,
@2 as Value
FROM
C:\Users\Administrator.QLIKVIEW\Downloads\ImgCount.txt
(txt, unicode, no labels, delimiter is ',', msq);
Main:
LOAD Date(Timestamp#(@1,'MM/DD/YYYY hh:mm:ss'),'MM/DD/YYYY') as TempDate,
@2 as Value
FROM
C:\Users\Administrator.QLIKVIEW\Downloads\ImgCount.txt
(txt, unicode, no labels, delimiter is ',', msq);
Main:
LOAD Date(Timestamp#(@1,'MM/DD/YYYY hh:mm:ss'),'MM/DD/YYYY') as TempDate,
@2 as Value
FROM
C:\Users\Administrator.QLIKVIEW\Downloads\ImgCount.txt
(txt, unicode, no labels, delimiter is ',', msq);