How to load this data in QlikView

[sona_sa]

Hi,

I am trying to load attached xls. But in Data dimension amount is not coming properly. Some date fields are coming. I am using below script - 

AOC_Cost:
CrossTable(MonthYear, Data, 4)
LOAD Division,
Functions,
[Functions 1],
Category,
[43922],
[43952],
[43983],
[44013],
[44044],
[44075],
[44105],
[44136],
[44166],
[44197],
[44228],
[44256]
FROM [..\SAMPLE DATA.xlsx] (ooxml, embedded labels, table is Sheet1);

AOC_Cost:
Load *,Date(num#(MonthYear,'#####'),'MMM-YY') as MonthNew
Resident AOC_Cost ;
Drop table AOC_Cost;
Exit Script;

Can anyone suggest, what need to do for the same.

Thanks.

[stevejoyce]

How about using num(Data) for a new field and drop original...

AOC_Cost:
Load *
,Date(num#(MonthYear,'#####'),'MMM-YY') as MonthNew
,num(Data) as DataNew
Resident AOC_Cost ;
Drop table AOC_Cost;

drop field Data;