Is there a way to assign values from one column across to other columns?

Hi there,

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.

Hi @etorres182 , you can take a look at the Rule Engine node.

@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!

Sure @etorres182 , but it would help if you could provide the sample data to work with.

Can you provide the data from the “Current Table” screenshot?

1 Like

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:

20221221_assign_values_column_across_v0.knwf (82.9 KB)

BR

1 Like

@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.

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.