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

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

Thu, 04 Sep 2014 16:05:32 GMT

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 — Thu, 04 Sep 2014 16:24:36 GMT

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