Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
load
id,
if(peek(id)=id,1) as Time2
resident Times;
inner join (Times)
load
'1' as NewField
resident Times;
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...
inner join (Times)
load
id,
if(peek(id)=id,1) as Time2
resident Times;