Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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