topic Re: Help: Use of Subroutines in QlikView

Help: Use of Subroutines

qlikviewforum — Wed, 26 Sep 2012 05:16:24 GMT

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

Re: Help: Use of Subroutines

Wed, 26 Sep 2012 05:24:22 GMT

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