topic Re: Help with script in QlikView

Help with script

hopkinsc — Tue, 23 Dec 2014 11:13:16 GMT

Hi All,

I have the following in my script which hard codes file locations..

For each vDirectory in 'C:\Temp1' ,'C:\Temp2'

I have a field in a QVD which holds all of the file locations i need. what i want to do is use that field instead of hardcoding.

At the moment the field isn't being loaded in at all, so i guess the first thing i need to do is load this field into its own table, but i do not know what to do after that.

Can anyone help please?

Re: Help with script

amit_saini — Tue, 23 Dec 2014 11:17:59 GMT

Hi,

You can do like below:

SET vSAP = 'Demo';

Directory \.......\SourceDocuments\qvd\SAP\$(vSAP)\;

Thanks,
AS

Re: Help with script

hopkinsc — Tue, 23 Dec 2014 11:20:11 GMT

sorry i dont understand. what does Demo relate to?

Re: Help with script

Tue, 23 Dec 2014 11:23:09 GMT

Hi Hopkinsc,

something like the below should work for you, you'll need to create a concat list from your qvd and then loop through based on that

(assuming your directory paths are in rows and not in a list already)

LOAD
Concat(Distinct DIRLIST,',') AS Dir_List
FROM
[YourQVDName.qvd]
(qvd);

Let vDirList = Peek('Dir_List');

For Each Dir In $(vDirList)

//your code here

Next

hope that helps

Joe

Re: Help with script

amit_saini — Tue, 23 Dec 2014 11:23:44 GMT

Say your Folder name is Demo from where you are reading your data.

Thanks,
AS

Re: Help with script

ThornOfCrowns — Tue, 23 Dec 2014 11:26:42 GMT

That what the OP has and is trying to avoid.

Re: Help with script

amit_saini — Tue, 23 Dec 2014 11:31:04 GMT

Sorry James my mistake

Thanks,

Re: Help with script

Colin-Albert — Tue, 23 Dec 2014 12:00:00 GMT

Try something like this

Tmp_dirlist:

LOAD concat( chr(39) & dirlist & chr(39), ',') as dirlist

From dirlist.qvd ;

LET vDirlist = peek(dirlist) ;

Drop table Tmp_dirlist;

For each vDirectory in $(vDirlist)

...( rest of your script)