Skip to main content

App Development

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

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Jonathan_Alm
Partner - Creator
Partner - Creator

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
Jonathan_Alm
Partner - Creator
Partner - Creator
Author