Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Excel document transformation

Hello everyone!

I have excel document:

Example.PNG.png

I need to transform it into:

Output.PNG.png

Any suggestions? Please help me.

1 Reply
Not applicable

Re: Excel document transformation

CrossTable(Oper, Data, 3)

LOAD Operation,

     F2,

     F3,

     [Planned maintenance],

     [Minor Repair],

     Cars,

     Buses,

     Trains,

     Repair,

     Cars1,

     Buses1,

     Trains1,

     [Major Repair],

     Cars2,

     Buses2,

     Trains2

FROM

(ooxml, embedded labels, table is Sheet1, filters(

Transpose(),

Replace(1, top, StrCnd(null)),

Replace(2, top, StrCnd(null))

));

Community Browser