Table pivot in Loading script

[Anonymous]

Hello All,

I am new on Qlikview so accept my apologizes if my question is too easy.

in a loading script I am loading a table like the one below:

Project	Est Cost 2017	Est Cost 2018	Est Cost 2019	Est Cost 2020
Proj 1	100	50	80	80
Proj 2	120	100	70	50
Proj 3	...	...
Proj 4

I would like to create in the script a table from the one above to look like the one below:

Project	Est cost	Year
Proj1	100	2017
Proj 1	50	2018
Proj 1	80	2019
Proj 1	80	2020
Proj 2	120	2017
Proj 2	100	2018
Proj 2	70	2019
Proj 2	50	2020
...

Would you know how to do that?

Regards,

Pierre.

[sergio0592 · Accepted solution]

Hi Pierre,

Take a look here. Cross table instruction will help you

The Crosstable Load

[el_aprendiz111]

Hi Pierre

tmp:
CrossTable(Year, [Est Cost])
LOAD * Inline
[
Project,Est Cost 2017,Est Cost 2018,Est Cost 2019,Est Cost 2020
Proj 1,100,50,80,80
Proj 2,120,100,70,50
Proj 3,90,90,,
Proj 4,,,10,1
];

NoConcatenate

SUMARY:
LOAD
Project,
[Est Cost],
Right(Year,4) as Year Resident tmp
Where [Est Cost]>0
;

DROP Table tmp;

[ankitasinghal]

Hi ,

You could also use Pivot chart directly and get this result.

Kindly find attached QV document in which i did same.

Thanks ,

Ankita

[Anonymous]

Thank you very much, it works great.

Regards,

Pierre.

[Anonymous]

Thank you very much for your help, this is ,perfect.

Regards,

Pierre.