This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Have one requirement:
1. Load multiple CSV files appended with date e.g: 2017-03-28 EMP Data.csv [Done]
2. based on file name date column need to be extracted[Done]
2. All csv files will be one single folder[Done]
3. Load all csv files and concatenate to one single table[Done]
4. After loading the files, old csv files will be deleted [Pending]
4. daily new file will be placed and append new file records to existing records in QV table[Pending]
PFA sample csv files and qvw
Can any one please let me know the incremental load logic need to be applied here.
Thank you used where condition and your script works fine, can please let me know any way we can achieve with our primary key
you can take max date from qvd and check the condition. Like extracted date of files should be greater than max date from qvd.
Let vFilePath = '1302030\*EMP Data.csv';
Let qvdExists = isNull(QvdCreateTime('1302030\EMP_Data.qvd'));
if $(qvdExists) < 0 then
Trace New file came.No Qvd is there;
Date(Left(FileName(),10),'YYYYMMDD') as Date_ID
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Trace New file came with existing qvd;
Load Max(Date_ID) as MaxDate
Let vMaxDate = Peek('MaxDate',0,'MaxDateQvd');
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
Bold part are changes in code.
Thanks once will try now
Sorry you're having trouble. My code would never just delete a QVD. There is no script in there that would delete a file. Worse thing any store command should do is create a QVD with no records in it.
Is that what is happening?
If so, the IF statement I had must not be 'catching'. I would check the file paths and no a debug to see what is happening.
If Ravi's code is working for you then go with that.
With Date > condition unique records are not getting recognized
Can you please explain on Unique record? It is based on what? EMPId or EMPId&Date ?