change the format of an excel sheet - Page 2 - Qlik Community

Anonymous · ‎2014-02-20

Dear All,

I need ur help to create a loop to change the position of rows in an excel sheet

let me explain1st table is the current format

the 2nd Table is the format i need

Anonymous · ‎2014-02-20

Dear Manish,

the problem is that your code requires that i write each column and i have more than 1000 columns

so i will have to write each column

can you help me ?

alexandros17 · ‎2014-02-20

I've tested the code I sent to you ... try it, let me know any problem

MK_QSL · ‎2014-02-20

Give me at least 10-15 columns...

You just have to write something like below..

CrossTable(Type, Value)

Load

Date,

Column1,

Column2,

...

From TableNameandLocation;