Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi qlikss,
I have 2 files in folder. Names of files.
I) daily_ 1.txt
Ii) daily_2.txt
I am loading into qliksense by using *
Load * from daily_*.txt.
When I load I want to check whether record exist in first table by using id field in tables.
How can I do this when I am loading like this.
Small correction
When I refresh at 11.30 am
Final table
1. 100
1. 200
6. 600
You want the latest id row. Use "where not exists(id) " but load the files ordered latest file first. You can build the list using "for each x in FileList()" or "First 1" like shown below. Here's an sample:
Files:
First 1
LOAD
FilePath() as FilePath,
FileTime() as FileTime
FROM
daily_*.txt
(fix, utf8, no labels);
Files2:
NoConcatenate
LOAD *
Resident Files
Order By FileTime desc;
Drop Table Files;
For i = 0 to NoOfRows('Files2')
LET vFile = Peek('FilePath', RecNo(), 'Files2');
Data:
LOAD *
FROM
[$(vFile)] (your filespec...
Where not exists(id)
;
Next i
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com