topic routine in script in QlikView

routine in script

Fri, 01 Oct 2010 21:42:01 GMT

Hi,

What I want to achive it's a routine, as a function or procedure with parametres, in the script.

What for? Because of Incremental Load.

The code I have for incremental Load, goes before the table. So, if i have 20 tables i'd have to copy the mentioned code before each one. It'd be perfect to create a function and call it before each table giving it parametres, as the name of the table and others if necesary.

Is it possible to do this in the script??

thxs in advance.

routine in script

pover — Fri, 01 Oct 2010 22:26:14 GMT

You can make a subroutine in the script like the following that is found the QlikView documentation:

// example 2 - parameter transfer
sub ParTrans (A,B,C)

A=A+1
B=B+1
C=C+1

end sub

A=1
X=1
C=1

call ParTrans (A,(X+1)*2)

In this case you might want to check out the for..each loop:

for each a in 1,3,7,'xyz'

load * from file$(a).csv

I hope that helps.