Discussion board where members can learn more about Qlik Sense App Development and Usage.
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;
inner join (Times)loadid,if(peek(id)=id,1) as Time2resident Times;
View solution in original post
inner join (Times)load
'1' as NewFieldresident Times;
But I would like to manipulate with the existing variables from the tables Times.
if(Id=(previous(id),1) as Time2
But it's not acceptet...