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
