topic Re: Adding variables after a join i load script in App Development

Adding variables after a join i load script

flemmingbj — Thu, 28 Nov 2019 12:10:03 GMT

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;

Re: Adding variables after a join i load script

lanlizgu — Thu, 28 Nov 2019 12:17:43 GMT

inner join (Times)
load

'1' as NewField
resident Times;

Re: Adding variables after a join i load script

flemmingbj — Thu, 28 Nov 2019 12:33:07 GMT

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

Re: Adding variables after a join i load script

lanlizgu — Thu, 28 Nov 2019 12:40:36 GMT

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