KNIME Cell Replacer

[@MistaYo9221]

Hello good video ! I have a question! Do you have any tips on improving data quality?

[@bytesandbudgets]

Thank you for the feedback. Well, that really depends on the input data. KNIME is pretty strong in data cleaning (with math nodes, string manipulator, rule engine etc)

[@stefan1221]

Do you have any recommendations to reduce the amount of nodes within a Knime workflow? I got several use cases where i ask myself „It should be possible to make such workflow even smaller“ . Once you understood certain nodes and how to use such nodes you probably gonna enhance or tremendously reduce the amount of used nodes to make such workflows as lean as possible. That`s why i love to use this tool and in addition Knime is the most flexible and scaleable tool i`ve ever experienced in my working time, til now. (IT related) - Would be nice to get you thoughts about my statement and to get a KZbin video where you probably suggest Best practices or an approach to thin out nodes from your workflows. Maybe Kind of use cases to Combine different nodes into one which is able to do the same procedure using nodes such as "Column expression" to replace others or eg. "Nominal Row Filter" vs. Row splitter" . Would be glad to get your opinion on that . Please keep on publishing . l really like how you explain things.

[@bytesandbudgets]

thanks a lot for your comment Stefan. Two nodes that immediately come into mind are Table Manipulator and Column Expressions The Table manipulator basically combines three / four "legacy" nodes into one: column rename, column resorter, column filter and - to a certain extent - the conversion nodes like string to number, number to string etc. The downside of this one is that it is a step away from the "one node, one task" paradigm. I also would recommend not to have too many Table Manipulators "in between" but rather apply the changes at the end. Column Expressions can be a great replacement for Rule Engines, Rule Engine Dictionaries, because you can treat a lot of columns in it. also in different ways (something the Rule Engine cannot do). The downside of this node is that you need to learn a bit of JavaScript to create the formulas for it. You can click a lot of stuff together in Column Expressions but for the part I didn't know about JS I usually ask chatGPT And then of course there are the "usual suspects" like Metanodes and Components in combination with "color coding" using Workflow Annotations. I am not sure, if any video I do will be better than the one that Scott Fincher already did on best practices to organize workflows, you might want to have a look at this: kzbin.info/www/bejne/jaOckHeQaZxkl6c Let me know, if this helped a little bit.

[@DDSPAD]

which version of knime are you using? bcos in the latest ver i.e. 5.2.5 I can't find the cell replacer node

[@bytesandbudgets]

Thank you for the comment. You are right, the Cell Replacer Node is now a deprecated node. But you could use its younger sibling, the Value Lookup Node instead. See also here: hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.preproc.valuelookup.ValueLookupNodeFactory/ Let.me know if this helps

[@DDSPAD]

@@bytesandbudgets Thnx a lot!

[@Tjay1896]

Thanks again for your quick reply. I did not expect that. Problem solved! What if the table A is part of an Excel file where there are several sheets? I want to execute the operation for each sheet. What do I have to pay attention to? I can really recommend a subscription to this channel, keep it up!

[@bytesandbudgets]

If Table A is part of an Excel file, you would probably use an Excel Reader Node where you can also define, which sheet is "imported" in KNIME. I have a whole series on these topics, if you might want to take a look into the playlists.