Qlik Community

Qlik Sense App Development

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

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Adding variables after a join i load script

How do I add and change variables in a newly created table in the load script?

I have joined two tables and want to create a new variable in the new table ("Times"), but it seems I don't have the samme options as with a "normal" load from a connection.  

 

Outer Join (Times) Load * resident Depotstop;

DROP Tables Depotstop;

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

inner join (Times)
load
id,
if(peek(id)=id,1) as Time2
resident Times;

View solution in original post

3 Replies
Highlighted
Creator III
Creator III

inner join (Times)
load

'1' as NewField
resident Times;

Highlighted
Contributor III
Contributor III

But I would like to manipulate with the existing variables from the tables Times.

E.g. 

if(Id=(previous(id),1) as Time2

But it's not acceptet...

Highlighted
Creator III
Creator III

inner join (Times)
load
id,
if(peek(id)=id,1) as Time2
resident Times;

View solution in original post