topic Re: File Copying and Renaming in QlikView

File Copying and Renaming

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

We are using Qlikview 11.2 in our company. I want to copy the .tab file from source location to the target location and in the target location the file name should be prefixed with the reloading date of the App.

I am just able to copy the file from source location to the target location but not able to prefix with the reloading date of the target file.

My code to copy the file is:

EXECUTE cmd.exe /C xcopy "D:\Source Loc\vectory.tab" "D:\Target Loc" /Y;

Please help me someone on this.

Thanks,

Veeranjaneyulu G

Re: File Copying and Renaming

oknotsen — Sun, 12 Feb 2017 17:56:49 GMT

Could you please explain to me what this has to do with QlikView?

I don't see the relation yet.

Re: File Copying and Renaming

Anonymous — Sun, 12 Feb 2017 18:23:22 GMT

Yup, Try Stack Overflow

Here is potential thread there, batch file - How to add date and time to filename in DOS? - Stack Overflow

Re: File Copying and Renaming

albertovarela — Sun, 12 Feb 2017 18:44:19 GMT

Here's a couple of options:

1) Load and rename/store using QlikView

- Execute the command line and keep the file name

- Load and store (with new name)

2) Use vbscript. I've used this in the past and works fine

https://www.experts-exchange.com/questions/28064320/Robocopy-and-rename-file-with-today

Re: File Copying and Renaming

Sat, 18 Feb 2017 11:53:43 GMT

Hi all,

This discussion helped me to solve my issue. Thanks everyone.

Re: File Copying and Renaming

Peter_Cammaert — Sat, 18 Feb 2017 14:14:09 GMT

If you found a solution, please close this discussion by marking the relevant answer as CORRECT. You can mark all other useful answers (if any) as HELPFUL by selecting the corresponding item from the Actions menu.

That way, other community members will know that this discussion contains a solution to a problem and isn't in need of any further answers.

Thanks