Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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\";
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.
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
Can you share your load script?