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

Fri, 21 Oct 2011 17:05:50 GMT

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

Fri, 21 Oct 2011 17:27:45 GMT

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.

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