Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qlikviewforum
Contributor II

Help: Use of Subroutines

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

1 Reply
Not applicable

Re: Help: Use of Subroutines

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

Community Browser