topic Re: read header date field as is in source in QlikView

read header date field as is in source

vireshkolagimat — Thu, 14 Apr 2016 13:45:02 GMT

Hi team,

I am loading the below data from excel sheet but i have the dates in header column.

After reloading the header column is stored as number. How to store it as date format as is in excel.

12/9/2015	12/13/2015
100	134
200	654
300	754
400	333

Regards,

Viresh

Re: read header date field as is in source

sunny_talwar — Thu, 14 Apr 2016 13:56:47 GMT

Try CrossTable() Load: The Crosstable Load

Re: read header date field as is in source

settu_periasamy — Thu, 14 Apr 2016 14:49:50 GMT

May be try like this, if you want the header as Date.. (May be there is a good suggestion)

SET DateFormat='M/D/YYYY';


Directory;
T1:
LOAD Num(A) as A, 
     Num(B) as B
FROM
[..\Book1.xlsx]
(ooxml, no labels, table is Sheet1);


Let vHeader1=Date(Peek('A',0,'T1'));
Let vHeader2=Date(Peek('B',0,'T1'));


NoConcatenate
T2:
LOAD A as '$(vHeader1)',
  B as '$(vHeader2)'
   
Resident T1 Where RecNo()>1;


DROP Table T1;

Re: read header date field as is in source

MarcoWedel — Fri, 15 Apr 2016 23:39:22 GMT

After crosstable loading the table you could join with a resident load having a newly created field

Date(yourcrosstabledatefield) as NewDate

Hope this helps

Regards

Marco Wedel

Re: read header date field as is in source

qlikview979 — Tue, 17 May 2016 06:24:25 GMT

Hi,

I am Not getting correct, can you try once with my source file.

Regards,

Mahesh.