hello everyone
always thank you for your support!
I would need, to select from an excel file (excel reder) the rows that have the following condition:
-) for each item select the first two shifts of the first day of production
original file
I’m new to Knime and there could be a more efficient way of doing it but please give it a try. I used a table creator to replicate your data. Please make sure you keep the same column naming so the flow works. Just eliminate the last three columns at the end with a node.
Nice approach @lazaronewhall17 Only remark I would have is that it’s sometimes better to go for inclusion instead of exclusion. In the Row Filter you now exclude a particular range. If for whatever reason the data changes it’s very likely that you will have additional records that pass through the row filter unintentionally because of this. Inclusion is therefore usually a more solid approach. In this case, you can opt to only include 1 and 2 for the Shift.
This assumes that the data sorted just like you have in your example. If not, add a Sorter node in between to arrange this. In this particular case, the group loop is also executed quicker due to the join() function in the Column Expression (2 ms vs 54 ms).
That is pretty interesting. Thanks for providing an alternate approach. Contributors like you really help user like me that are starting and encourage us to keep learning. Also, thanks for explaining the inclusion/exclusion approach. Makes total sense. Thanks