Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

riishabhz
Contributor

load multiple txt files everyday

hi , i have txt files which are coming from ftp daily, i want to load it everyday with script and move that files into old folder so that next day it wont load again. my script is working but problem is that when new file loads the previous txt gets deleted from qlikview. hope you understand it.

my script :-

load a,b,c,d

FROM
C:\Users\dmsadmin\Desktop\riishabhz\New folder\MAT_MAS\MAT_MAS_*.txt
(txt, codepage is 1252, embedded labels, delimiter is '|', msq);

EXECUTE cmd.exe /C move "C:\Users\dmsadmin\Desktop\riishabhz\New folder\MAT_MAS\*.*" "C:\Users\dmsadmin\Desktop\riishabhz\New folder\old\";

3 Replies
mwoolf
Honored Contributor II

Re: load multiple txt files everyday

If you want the old text files to still be in QlikView, you have to load them every day.

A slightly more complex solution is to load the text files into a qvd. Then daily, you could incremental load the qvd with the new text files only.

riishabhz
Contributor

Re: load multiple txt files everyday

i made qvd but its saving only first txt file into qvd dont know why,

there are more then 50 txt files but qvd is saving only first one

mwoolf
Honored Contributor II

Re: load multiple txt files everyday

Can you share your load script?