topic Re: Looping multiple times in QlikView

Looping multiple times

Wed, 20 Jan 2016 20:15:13 GMT

How can I modify the script below to loop through each QVD file location? The script looks at a file location for a QVD, grabs the name of the table and counts the records in that table. I would like to do it multiple times through multiple locations.

let numRows = QvdNoOfRecords('\\filename.qvd');

let table = QvdTableName ('\\filename.qvd');

recordCount:

load * inline [

QvdTableName,numRows

$(table),$(numRows)

];

Re: Looping multiple times

Wed, 20 Jan 2016 21:04:08 GMT

You can loop through For Next loop in the script:

Find below sample snippet

SUB DoDir (Root)

FOR Each File in filelist (Root&' \*.qvd')
let numRows = QvdNoOfRecords('$(File)');
let table = QvdTableName ('$(File)');
recordCount:
load * inline [
QvdTableName,numRows
$(table),$(numRows)
];
NEXT File

FOR Each Dir in dirlist (Root&' \*' )
call DoDir (Dir)

NEXT Dir

ENDSUB

CALL DoDir ('C:')

Re: Looping multiple times

Wed, 20 Jan 2016 21:16:05 GMT

Do I put this in my load script?

Re: Looping multiple times

Wed, 20 Jan 2016 22:07:43 GMT

Hi,

What if I need to look into different instances as well like dev, QA, UAT and Prod.

Re: Looping multiple times

Peter_Cammaert — Wed, 20 Jan 2016 23:09:15 GMT

Yes.

There are two parts in this piece of code. A SUB...END SUB definition which defines but doesn't execute a callable procedure, and the CALL of that same SUB (last line) which executes the procedure with a starting directory as parameter.

Always put the definition before the first CALL or you will get a script error. You can put the definition on the first script tab (together with any other SUB definition), and CALL it anywhere else on the following tabs.

Peter

Re: Looping multiple times

swuehl — Wed, 20 Jan 2016 23:17:37 GMT

Just out of curiosity, is your original code snippet part of a learning exercise?

Count of records

Re: Looping multiple times

Peter_Cammaert — Wed, 20 Jan 2016 23:31:07 GMT

I think your answer has just arrived (3 posters asking for the same solution)