Adding variables after a join i load script

[flemmingbj]

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;

[lanlizgu]

inner join (Times)
load

'1' as NewField
resident Times;

[flemmingbj]

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...

[lanlizgu · Accepted solution]

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