Moving file from one folder to another folder

[Anonymous]

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,

[its_anandrjs]

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

[Anonymous]

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,

[its_anandrjs]

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

[tobias_klett]

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