KNIME Loops - Day 39 - 66 Days of Data

[@rashedalnaamani]

Congratulations 🎉🎉🎉 Phil…well deserved for the certification …by far you are the best who explain and describe knime in a very simple way…you don’t know how you made my life simpler

[@procurementzen]

Wow Rashed. Really appreciate your feedback. This made my day. I was hoping that it benefits some other friends out there (besides my own ego) and this confirms it helped. Awesome, thank you again!

[@PedroReus-ur4hq]

Hi Phil, good afternoon, I'm looking at the following about the video of day 39: I don't understand why when the node called "columns rename" is occupied, when occupying the variable functionality, the option called "old_column_name" must be selected?

[@procurementzen]

Thank you for the question Pedro. You want to give the column a "generic name" through using the flow variable functionality because otherwise in the next loop iteration the column to be renamed (the next bin so to say) holds another column heading / name. Then the string maipulation node doesn't work anymore because it would look for that name from the previous iteration which is no longer there. Example (without renaming): Iteration 1 - column name: col1 - String Manipulation looks for "col1", finds it and executes Iteration 2 - column name: col1 - String Manipulation looks for "col1", doesn't find it and breaks Example (with renaming): Iteration 1 - column name: col1 - renamed to "generic col" - String Manipulation looks for "generic col", finds it and executes Iteration 2 - column name: col2 - renamed to "generic col" - String Manipulation looks for "generic col", finds it and executes Hope that helps :)