Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try CrossTable() Load: The Crosstable Load
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;
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
Hi,
I am Not getting correct, can you try once with my source file.
Regards,
Mahesh.