Help: Use of Subroutines

[qlikviewforum]

Hi

How can I make use of Subroutines to reduce the number of codes instead of using the load statement which is almost similar. Like calling a call subroutines instead of repeating similar lines of code.

Load a as a1,

        b as b1,

        c as c1

Resident Table1;

CONCATENATE

Load a as a1,

        b as b1,

        c as c1

Resident Table2;

Thanks

qlikviewforum

[#2]

You can try this for loop statement.

Load a as a1,

        b as b1,

        c as c1

Resident Table1;

for a=2 to 9

Concatenate

Load a as a1,

        b as b1,

        c as c1

Resident Table$(a);

next

Regards,

Janzen