i have data like in excel sheet(Crosstab format),i am importing data in qlikview date format is not coming

[#1]

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.

[stevedark]

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