Hi, I wanted to append conditional in my table through knime. Is there node/workflow to enable this?
for instance:
This is my raw data
Description |
Total |
App Red 6x12 |
72 |
App Orange 6x12 |
72 |
Grp Red 1x1 |
1 |
Bnn Yellow 1x1 |
1 |
This is my desired output based on conditional for append column in category and area:
Description |
Total |
Category |
Area |
App Red 6x12 |
72 |
Apple |
Box |
App Orange 6x12 |
72 |
Apple |
Box |
Grp Red 1x1 |
1 |
Grape |
Piece |
Bnn Yellow 1x1 |
1 |
Banana |
Piece |
Thanks!
ipazin
2
Hi there @andersenyunan,
sure there is! You can try Rule Engine in combination with some pre-processing before or Column Expressions node can be a one solution node.
Br,
Ivan
Hi @ipazin
thanks for responding!
Is it also possible to list multiple condition inside? sort of like IFS like in excel for multiple conditional.
ipazin
4
Hi @andersenyunan,
yes it is. Take a look at node descriptions. They contain examples. Also you can find example workflows with this nodes on KNIME Hub.
Br,
Ivan
1 Like
system
Closed
5
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.