How can I create a new variable in a table without reloading the input data each time.

[#1]

See example code below.

I want to create a new variable in a table without having to reload the input data each time.

(ie run the code on lines 15 to 23 without having to run the code on lines 1 to 13 each time)

1 Table1:
2

3 LOAD * INLINE [
4    a, b
5    1, 2
6 ];
7

8 concatenate
9

10 LOAD * INLINE [
11    a, b
12    3, 4
13 ];                                                                

14
15 Table2:
16

17 Load a,
18     b,
19     b*10 as c
20

21 resident Table1;
22

23 Drop table Table1

[#2]

You can use the below code from line 15 to 21.

if isPartialReload() then

     Table2:

     Replace

     Load a, b,b*10 as c

     resident Table1;

EndIF

But I doubt the necessacity since if you drop Table1, you cant use it the next time.

Kiran.