Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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