Does anyone know if there is a way to assign values from one column cross to other columns based on a criteria? So, for example, if I have 6 minutes that I would like to allocate to a specific column based on its status, how can I do that, if all statuses are the same, and only take the the last column status to assign a value to?
I may not be clearly expressing what I am trying to do here, so I am attaching a screenshot. I am basically trying to find out how long it takes to collect a bag from either the Area, Aisle, etcā¦ These columns are in order From Area(first) to Location (Last). If the Status Co-Located is in any of the columns, I would like to allocate the ātime to allocā to the last column with the āCo-locatedā status, otherwise we assign it a 0.
@bruno29a , any chance you can provide an example? Iāve already used that node and it doesnāt do what I need it to do, and so, I may be doing it wrong. An example would be amazing. Thank you!
Hello @etorres182
For a use case with limited (and short) number of columns, consecutive āRule Engineā nodes can do the job. The concatenated Rule Engine example is included in the workflow.
For a generic approach, here is my alternative workflow:
@gonhaddock , that is exactly what I was looking for. I was able to apply this directly to my own KNIME Flow. Thanks so much! This fixed the issue I was having. I really appreciate your quick response!
@bruno29a, thanks for offering your help! I really appreciate it.
