File Copying and Renaming

[#1]

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

[oknotsen]

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

I don't see the relation yet.

[Anonymous · Accepted solution]

Yup, Try Stack Overflow

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

[albertovarela]

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

[#5]

Hi all,

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

[Peter_Cammaert]

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