Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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))

));