Loading data from exel

[#1]

Please help,

I cant load correctly data from exel, i dont know ho to correctly configure cross table setings (or maybe i dont need cross table).

[dharmarasu]

hi,

hope this helps you..

in edit script, copy and paste it..

CrossTable(period,value,7)

LOAD MARKET,

     CATEGORY,

     CLASS,

     Manuf,

     Brand,

     'Fact1' as Fact,

     Product,

     Period1,

     Period2,

     Period3,

     Period4,

     Period5,

     Period6,

     Period7,

     Period8   

FROM

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

CrossTable(period,value,7)

LOAD MARKET,

     CATEGORY,

     CLASS,

     Manuf,

     Brand,

     'Fact2' as Fact,

     Product,      

     Period11 as Period1,

     Period21 as Period2,

     Period31 as Period3,

     Period41 as Period4,

     Period51 as Period5,

     Period61 as Period6, 

     Period71 as Period7,

     Period81 as Period8

FROM

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

CrossTable(period,value,7)

LOAD MARKET,

     CATEGORY,

     CLASS,

     Manuf,

     Brand,

     'Fact3' as Fact,

     Product,      

     Period12 as Period1,

     Period22 as Period2,

     Period32 as Period3,

     Period42 as Period4,

     Period52 as Period5,

     Period62 as Period6, 

     Period72 as Period7,

     Period82 as Period8

FROM

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

Dharma

[Gysbert_Wassenaar · Accepted solution]

The crosstable function cannot handle multiple horizontal dimensions. You can try separate loads for each fact. See attached qvw.

[#4]

Thanks for fast replays!!

Works fine, but i dont understand some script details..

"1 as Fact" - in my exel it caled Fact1, why you named it 1?

     "Period11 as Period1,

     Period21 as Period2,

     Period31 as Period3,

     Period41 as Period4,

     Period51 as Period5,

     Period61 as Period6,

     Period71 as Period7,

     Period81 as Period8"

How do i now what number of period is?

[Gysbert_Wassenaar]

A mistake. Change it to 'Fact1' if you need that instead of 1.

[#6]

ok, understand

so what about period numbers?

[#7]

from where you get Period11, Period21, Period 31, etc?  

    "Period11 as Period1,

     Period21 as Period2,

     Period31 as Period3,

     Period41 as Period4,

     Period51 as Period5,

     Period61 as Period6,

     Period71 as Period7,

     Period81 as Period8"

[#8]

Find my self thanks for all, case closed.