Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
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
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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