topic Re: Incremental Load Scenarios: Move or Delete Source Files in QlikView

Incremental Load Scenarios: Move or Delete Source Files

cbaqir — Sat, 16 Nov 2024 21:08:04 GMT

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?

Re: Incremental Load Scenarios: Move or Delete Source Files

dplr-rn — Tue, 02 Apr 2019 14:49:20 GMT

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

Re: Incremental Load Scenarios: Move or Delete Source Files

cbaqir — Tue, 02 Apr 2019 14:50:47 GMT

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

Re: Incremental Load Scenarios: Move or Delete Source Files

dplr-rn — Tue, 02 Apr 2019 14:50:56 GMT

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/ScriptRegularStatements/Execute.htm

Re: Incremental Load Scenarios: Move or Delete Source Files

dplr-rn — Tue, 02 Apr 2019 14:55:24 GMT

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.

Re: Incremental Load Scenarios: Move or Delete Source Files

dplr-rn — Tue, 02 Apr 2019 14:56:52 GMT

please close thread if it helped

Re: Incremental Load Scenarios: Move or Delete Source Files

cbaqir — Tue, 02 Apr 2019 14:59:30 GMT

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

Re: Incremental Load Scenarios: Move or Delete Source Files

dplr-rn — Tue, 02 Apr 2019 15:04:04 GMT

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