topic load multiple txt files everyday in QlikView

load multiple txt files everyday

riishabhz — Wed, 25 Nov 2020 16:16:04 GMT

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\";

Re: load multiple txt files everyday

m_woolf — Mon, 29 Jul 2019 11:45:33 GMT

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.

Re: load multiple txt files everyday

riishabhz — Mon, 29 Jul 2019 11:53:27 GMT

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

Re: load multiple txt files everyday

m_woolf — Mon, 29 Jul 2019 14:17:46 GMT

Can you share your load script?