topic Re: Moving file from one folder to another folder in QlikView

Moving file from one folder to another folder

Anonymous — Thu, 19 Feb 2015 07:01:39 GMT

Hi,

I have more than 2 .csv files i have to create qvd's for 3 files.after creating of qvd's i have to move that files to another folder.

Please help me.

Thanks,

Re: Moving file from one folder to another folder

its_anandrjs — Thu, 19 Feb 2015 07:31:14 GMT

Hi,

You can try this ways

Let vCSVLocation = 'D:\Folder\';

Let vCSVToQVD = 'E:\QVDLocation\';

Tab1:

Load

From $(vCSVLocation)*.csv

Store Tab1 into $(vCSVToQVD)Tab1.qvd;

Regards

Anand

Re: Moving file from one folder to another folder

Anonymous — Thu, 19 Feb 2015 07:35:12 GMT

Hi Anand,

Thanks for your response,

I created qvd .what my exact need is after creation of qvd. i want to move the source file from one place to another place.

Thanks,

Re: Moving file from one folder to another folder

its_anandrjs — Thu, 19 Feb 2015 07:40:46 GMT

Hi,

You can trigger the Bat file for this i suggest means after loading data from the Source Run Bat file for Moving option in the bat file.

Regards

Anand

Re: Moving file from one folder to another folder

tobias_klett — Thu, 19 Feb 2015 08:27:11 GMT

Hi chandini,

depending on security settings you can use execute statements in the script.

Example:

Create the following TXT file:

C:\temp\Test_Execute_existing.txt

Put a QVW File next to it with the following script:

EXECUTE cmd.exe /C > C:\temp\Test_Execute_create.txt echo created File Input;
EXECUTE cmd.exe /C copy C:\temp\Test_Execute_existing.txt C:\temp\Test_Execute\Test_Execute_copy.txt;
EXECUTE cmd.exe /C del C:\temp\Test_Execute_existing.txt;

See what happens if you run the script and allow to override security.

Hope this helps

Tobias