excel source problem

[#1]

hi,

i have a problem with regards to my source. how can i load this so that i will only have a moth field instead of jan, feb mar etc..

see attached file

[#2]

Hi,

You need to do a cross table. Use script below

Forums:

CrossTable(Month, Val, 5)
LOAD Field1,
Field2,
Field3,
Year,
Field4,
1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11,
12
FROM
C:\Downloads\forums.xlsx
(ooxml, embedded labels, table is Sheet1);