Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there.
I have a problem and I can't seem to fix it in my load editor I want to import only the values of the latest row found for each Kenteken. So for instance a Kenteken xx-00-xx can be on row 12000 and the same one xx-00-xx can be on 14000. I only want to import the latest row with that particular kenteken and other fields in order to get rid off duplicates. I want it to be done in the load editor and not in the front-end.
Unfortunately I can't do anything with dates because they can be similar and there are too many variances.
This is the script:
Hi, could you share a few lines of the dataset.
Sure thing. This is an example how it may look. Unfortunately date can't be used since sometimes the date can be the same for 4 instances for example. In this case I want to take row number 3 and not import number 2, because the a higher row number means that it is being imported later.
Of course the dataset consists of multiple 100.000 rows.
Try
Data:
LOAD AutoNumber(Recno(),Kenteken) as %Key
*
FROM Source;
Inner Join
LOAD Max(%Key) as %Key
Resident Data;