transform excel table

[l_wassler]

hi,

i would like to import a excel sheet which has this structure:

itemnumber	accountnumber	t01	t02	t03	t04	t05	t06	t07	t08	t09	t10	t11	t12	q01	q02	q03	q04	q05	q06	q07	q08	q09	q10	q11	q12
16010	10127	1	0	1.6	2.2	3.1	1.4	1.6	0.9	5.2	2.3	9.7	7.2	0.7	0.0	1.1	2.0	2.5	1.2	1.1	0.7	4.4	2.0	6.8	5.3

but i want to import it with this structure:

itemnumber	accountnumber	month	turnover	qty (in tons)
16010	10127	jan or 01	1.0	0.7
16010	10127	feb or 02	0.0	0.0
16010	10127	mar or 03	1.6	1.1
16010	10127	apr or 04	2.2	2.0
16010	10127	may or 05	3.1	2.5
16010	10127	jun or 06	1.4	1.2
16010	10127	jul or 07	1.6	1.1
16010	10127	aug or 08	0.9	0.7
16010	10127	sep or 09	5.2	4.4
16010	10127	oct or 10	2.3	2.0
16010	10127	nov or 11	9.7	6.8
16010	10127	dez or 12	7.2	5.3

is there a way to realize this in the script or with the table wizard? or do i have to realize this in excel with VBA?

[#2 · Accepted solution]

Hi,

Take a look at the below post. It has same requirement as yours.

http://community.qlik.com/forums/p/17151/67145.aspx#67145

- Sridhar

[l_wassler]

aah ok,

thank you for your quick reply

[prieper]

Hi,

would suggest to

1. look at turnover and quantity separately
2. normalize the table using CROSS-TABLE
3. JOIN the tables separately

HTH

Peter

[prieper]

cannot edit my message above - postings have crossed: suggestion from Sidhar is the better one

Peter