I have a table with 4000 rows. This table represents attendance records, including employee codes, dates, and times for clocking in and out. I would like to compare each row based on the employee code, date, and time difference between two consecutive records. If the time difference is less than 1 hour and the status is ‘IN,’ I want to keep the first ‘IN’ record. If the status is ‘OUT’ and the time difference is less than 1 hour, I want to keep the last ‘OUT’ record. Could you please provide details on how I can accomplish this in KNIME?
Maybe, firstofall, i suggest to put the “in” and “out” as columns headers to make an easier way to compare at the same line, not between to lines.
You can use the pivot node to put it together if you have the same ID and date as parameters. With these 2 columns, you can use Date&time Diff to bring the value about this calc. Then you can use the rule engine node to test your hypotheses and set a filter or a value like true or false.
Can you do it or bring a dummy example as wf here?
