Not applicable
2014-09-04
12:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i have data like in excel sheet(Crosstab format),i am importing data in qlikview date format is not coming
Func | 2/24/2014 | 2/25/2014 | 2/26/2014 | 2/27/2014 | 2/28/2014 | 3/1/2014 | 3/2/2014 | 3/3/2014 |
A | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |
A | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |
A | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |
A | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |
A | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |
Hi,
Please find the above i have data like in excel sheet(Crosstab format),i am importing data in qlikview date format is not coming
properly,please suggest us the solution
Thanks,
Rao.
1,746 Views
1 Reply
stevedark
Partner Ambassador/MVP
2014-09-04
12:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Rao,
You will need to do the crosstable load into a temporary table, and then do a resident load where you format the date correctly.
Something like:
Temp_CT:
CROSSTABLE (RawDate, Value, 1) LOAD
*
FROM Source;
Data:
LOAD
Func,
Date(Date#(RawDate, 'M/DD/YYYY'), 'DD MMM YYYY') as Date,
Value
RESIDENT Temp_CT;
DROP TABLE Temp_CT;
Hope that helps,
Steve
736 Views