Transform table in script

[Jonathan_Alm]

Hi,

I have a table that looks like this:

Name	Content	Key
Firstname	John	1
Lastname	Andersson	1
Age	30	1
Firstname	Carl	2
Lastname	Johnsson	2
Age	40	2
Firstname	Lisa	3
Lastname	Snow	3
Age	50	3

I would like to create a table that looks like this:

Key	Firstname	Lastname	Age
1	John	Andersson	30
2	Carl	Johnsson	40
3	Lisa	Snow	50

Is there a way to make this in the script while loading this data? 

Today the data is loaded like this:

LOAD

Key,

Content AS Firstname

FROM

data.qvd (qvd)

WHERE 

name = 'Firstname';

JOIN

LOAD

Key,

Content AS Lastname

FROM

data.qvd (qvd)

WHERE 

name = 'Lastname';

...

...

and so on

Kind regards, Jonathan

[Jonathan_Alm · Accepted solution]

Found the answer.

https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470