Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Jonathan_Alm
Partner
Partner

Transform table in script

Hi,

I have a table that looks like this:

NameContentKey
FirstnameJohn1
LastnameAndersson1
Age301
FirstnameCarl2
LastnameJohnsson2
Age402
FirstnameLisa3
LastnameSnow3
Age503

 

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

KeyFirstnameLastnameAge
1JohnAndersson30
2CarlJohnsson40
3LisaSnow50

 

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

1 Solution

Accepted Solutions
1 Reply