read header date field as is in source

[vireshkolagimat]

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

[sunny_talwar]

Try CrossTable() Load: The Crosstable Load

[settu_periasamy]

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;

[MarcoWedel]

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

[qlikview979]

Hi,

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

Regards,

Mahesh.