Qlik Community

Qlik Scalability

A group dedicated to advancing Qlik scalability and performance. In this group we will share knowledge on how to perform load tests of Qlik products.

Highlighted
Not applicable

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

Func2/24/20142/25/20142/26/20142/27/20142/28/20143/1/20143/2/20143/3/2014
A5050505050505050
A5050505050505050
A5050505050505050
A5050505050505050
A5050505050505050

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 Reply
MVP & Luminary
MVP & Luminary

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

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