topic Copying file from one to another location using script in QlikView

Copying file from one to another location using script

Sun, 13 Mar 2011 13:00:31 GMT

Hi,

I want to generate qvd files at another folder 'QVD' from csv files which are placed in folder 'CSV'.

How to define the path or how to move or copy the files from CSV folder to 'QVD' folder?

Thanks.

Samir

Copying file from one to another location using script

Sun, 13 Mar 2011 14:39:35 GMT

Any idea please...

Copying file from one to another location using script

jonathandienst — Sun, 13 Mar 2011 15:17:10 GMT

Samir

DataTable:
LOAD ... <load fields here> ...
FROM <path to CSV file>\file.csv
(..);
....
STORE DataTable into <path to QVD folder>\file.qvd (qvd);

Where the paths can be absolute (eg E:\QVDATA\CSV) or relative to the folder containg the QV model (eg ..\QVDATA\CSV)

Hope that help (or have I missed the point)?

Jonathan

Copying file from one to another location using script

Sun, 13 Mar 2011 15:28:37 GMT

Hello Jonathan,

I am creating multiple QVD file using the following code:

For

each File in filelist('D:\QlikView Dynamic Reporting\15-Feb-2011\Producer\Feb\*.csv')

TableName:

LOAD

FROM

[$(File)](txt, codepage is 1252, embedded labels, delimiter is ',', msq);

STORE

drop

Next

table TableName;TableName INTO $(File). qvd (qvd);hash128(fileName(), RowNo()) AS line, [userId] as LOGIN_ID, sessionId

************************************

In this condition I am getting idea how to find the name of the file and copy/move to the another folder?

Sorry for the confusion,

Thanks

Samir

Copying file from one to another location using script

Sun, 13 Mar 2011 15:35:54 GMT

Sorry my reply was not well formatted, I wrote in well format, but after posting the reply it appeared weired.

Again I am writing my sample code:

For each File in filelist('D:\QlikView Dynamic Reporting\15-Feb-2011\Producer\Feb\*.csv')
TableName:
LOAD
hash128(fileName(), RowNo()) AS line,
[userId] as LOGIN_ID,

FROM
[$(File)]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
STORE TableName INTO $(File).qvd (qvd);
drop table TableName;
Next

Here I am not getting any idea how to get the generated QVD file name and copy to some other folder?

Thanks

Samir

Copying file from one to another location using script

jonathandienst — Sun, 13 Mar 2011 15:37:01 GMT

Samir

Please copy your code into a text editor (notepad is fine) and then paste into the forum. I simply cannot make sense of what you have posted.

I am still not sure exactly what you are asking.

Jonathan

-- edit -- the first part refers to the earlier post - I see that you have fixed tha -- end edit --

Copying file from one to another location using script

jonathandienst — Sun, 13 Mar 2011 15:39:46 GMT

Samir

STORE TableName INTO <qvd path here>\$(File).qvd (qvd);

Is that what you are looking for?

Jonathan

Copying file from one to another location using script

Mon, 14 Mar 2011 05:03:43 GMT

Hello Jonathan,

My code is as following:

Suppose I want to copy the generated QVD file at the following location :

D:\QlikView Dynamic Reporting\15-Feb-2011\Feb-QVD

and if I provide the destination location as :

STORE TableName INTO D:\QlikView Dynamic Reporting\15-Feb-2011\Feb-QVD\$(File).qvd (qvd);

The resultant code is as following taken from debug console:

STORE TableName INTO D:\QlikView Dynamic Reporting\15-Feb-2011\Feb-QVD\D:\QlikView Dynamic Reporting\15-Feb-2011\Producer\Feb\pages_20110201.csv.qvd (qvd)

How to extract only the file name from the variable 'File' written in my code snippet, then append it to the desination path?

Thanks

Samir

Copying file from one to another location using script

jonathandienst — Mon, 14 Mar 2011 05:38:17 GMT

Samir

OK, now I understand. You can use a subfield to extract the filename.Unfortunately, the FileName() function does not work in this context. The file name is the text after the last back slash, so something like:

Let vFileName = Subfield(File, '\', SubstringCount(File, '\')+1); // to strip the path
Let vFileName = SubField(vFileName, '.', 1); // to strip the extension
STORE into  (qvd);

Hope that helps

Jonathan

Copying file from one to another location using script

Mon, 14 Mar 2011 09:47:20 GMT

Hello Jonathan,

Thanks for your valuable and quick response. It worked perfectly.

Thanks

Samir

Copying file from one to another location using script

Mon, 14 Mar 2011 11:25:27 GMT

good

Re: Copying file from one to another location using script

Mon, 03 Jun 2013 15:18:16 GMT

hi all,

can anyone tell me how to copy all files from particular location to another location?