topic Re: loading of files from source folder to destination folder through script in QlikView

loading of files from source folder to destination folder through script

shree909 — Wed, 10 Apr 2013 18:51:47 GMT

Hi ,

I have a scenario where i get the files daily.

Example abc1.txt

abc2.txt,

abc3.txt and so on... // these files are in source directory

Now i want to generate a qvd from the existing files and move to destination directory...

when ever a new files are added to the source directory daily. so the next time when i generate a qvd it should load only files that are added are not present

and store as a new qvd in the destination directoy..

Thanks

sri

Re: loading of files from source folder to destination folder through script

Anonymous — Thu, 11 Apr 2013 01:03:49 GMT

Hi,

Something along the lines of this:

Let vDate = Today();

T1:

Load

From \\Machine\folder\abc*.txt;

Store T1 into \\Machine\Folder2\ABC_$(vDate).qvd;

Drop table T1;

Re: loading of files from source folder to destination folder through script

narender123 — Thu, 11 Apr 2013 10:47:09 GMT

Hi Shree

When ever you create a new qvd ,you should drop that new qvd in the same location after store command.

Eg.

New:

Load

Name,

City,

Address

from ...........*.txt;

Store NEW into \\your path location....\NEW.qvd

Drop Table NEW;

So in next time you can store another qvd like NEW2,after that drop theNEW2 qvd.

I think this will help you. Try it.

Thanks.

Regards:

Narender

Re: loading of files from source folder to destination folder through script

shree909 — Thu, 11 Apr 2013 19:18:36 GMT

thanks for the reply ..

i want to move the files that are source directory to the destination directory..

once the files are processed and generated a qvd then i want to move the source files(.csv ) files into the destination directory...

Re: loading of files from source folder to destination folder through script

Mon, 03 Jun 2013 15:26:34 GMT

hi all,

cany anyone tell me how to copy all files from one folder to another folder in qlikview

Re: loading of files from source folder to destination folder through script

evan_kurowski — Tue, 15 Apr 2014 21:00:03 GMT

Hello Shree,

To actually move the source files from their original directory to the archive directory, you will have to enable file system access in the application.

Once that is done you can then use the EXECUTE command in order to actually run the DOS command for moving a file from location A to location B.

If you just wanted to make a copy of the file in .CSV format and save it in a second location, you could use the following syntax with the (txt) argument of the STORE command.

[input_csv]:

LOAD *
FROM [$(vOriginalLocation)\ORIGINAL.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

STORE * FROM input_csv INTO [$(vOutputLocation)\CSV_from_QV_output.csv] (txt);

Re: loading of files from source folder to destination folder through script

Anonymous — Tue, 15 Apr 2014 21:01:43 GMT

The post on this thread from Evan Kurowski was accidentally. In order to restore points to all participants I have copied and reinserted this comment. Thanks for your patience!

"Script Execution Progress" window hangs