Incremental Load Scenarios: Move or Delete Source Files

[cbaqir]

I am converting a QVW with a QVD into an Incremental Load with an automated Managed File Transfer to move my source files (CSV) into my QV server folder. I've found references on how to do an insert but I don't see anything explaining what to do with the old files. I will have a LOT of files on a daily or weekly basis. How do I move or delete them once used?

[dplr-rn]

Do you mean delete older csv files
try something like
execute cmd.exe /c del *.csv;
replace * with your logic

[cbaqir]

Yes! Thanks. I didn't know it was so easy. Just put that in the script after the QVD is updated?

[dplr-rn]

if you are using QV server you will have to enable execute
https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Sc...

[dplr-rn]

Yes after you have finished reading relevant csvs and stored it.
or you could move it to an archive folder

personally i am vary of execute because of security . not sure when qlik may disable it.

[dplr-rn]

please close thread if it helped

[cbaqir]

Can I use the script to move the files to an archive folder?

[dplr-rn · Accepted solution]

execute can be used to run most windows commands
so something like below should work.
execute cmd.exe /c copy *.csv \backuppath\