Knime Crash Course: Your first KNIME Workflow  

Thanks a lot for the feedback and I really appreciate your feedback. New videos will be coming soon 😉

Thanks a lot, Jana, glad to be helpful. Hope it gave a good intro and that you are satisfied with the rest (so far) of the course. 😀

Awesome, glad you like it and happy that even on the opposite side of the globe this helps 😉

Thank you, pretty glad that you like it. Fun fact is that I considered this video to be to "complicated" but it seems to be quite popular.

Thank you very much for the kind words. Let me know through your comments if anything is unclear and I make sure to find a solution

Thanks a lot for your nice words, makes me smile 😀 Happy to share the knowledge

Thank you for your kind words, happy that you like it.

Thank you a lot Raheem. Glad that you found it useful. If at any stage questions or problems occur, come here and let me know through a comment. I am happy to help

Thank you, dmmmm :) Glad that it helped.

Thanks a lot, Salim ... really appreciate your kind words. :) Let me know, if there are any questions.

Awesome, really glad you like it! Just ping me here via comments, if anything is unclear. I'm happy to support you.

Thank you ,glad you like it

Thank you a lot for the comment, I really appreciate it. Hope you find more good stuff in this content and if there is any question, just comment, I try to help as much as I can 😃

Thank you for the feedback, Tomasz 🙏 I hoped that it came across in an understandable way 😀👍

@@procurementzen Yes it did 🥳

Thanks a lot. Glad that it is of help. Hope the other episodes benefit you as well :)

Great that you like it. It has definitely changed my way of dealing with data and approaching "programming" (there, I said it 😄)

Thanks a lot, Rationale !! :) I appreciate that you took the time to comment. We're going also much more into detail (the why and how) in the lessons / videos 📹that follow 😏

Thanks a lot for the kind words. Here's the workflow on the hub: hub.knime.com/-/spaces/-/~AcGhvMziu4hdT4si/current-state/ I also added this to the video description 😃

Thank you 😃

Thank you a lot Majid, glad you like it. Let me know, if anything is unclear or if I can help

thanks a lot for the comment, great that you like it 😀

@@procurementzen Yes!!! I think your videos are very very understandables and I am learning a lot with them. I consider them as a big gift!!! Thanks!!

more than welcome, hope I could share a bit of knowledge 😀

😂 Thank you, although I am not a good guitar player 😉

sweet, glad that you liked it 😀 sharing is caring

Hi JR, sorry for not getting back earlier. These node numbers (so to say) like 4:1 or 0:1 really don't matter. It's an internal numbering that is used also in the console e. g. when there is an error and you need to look up in which node it happened. As long as you get the same results from the Excel Reader Node, you should be good to go.

yes, absolutley. Just make sure that the metanodes have flow variable in- and output ports to route the variables through them. if you want to do repetitive work e. g. per row of data, a lot of the manipulation nodes (yellow 1s) work on a row basis, or - if you have a combo of nodes that should repetitively do stuff per row - you could also use a loop. Hopefully this answers your questions.

Sure. I would suggest you contact me via phil@procurementzen.com

Thank you a lot for the comment. Not sure if direct translation - let's say from German to English - is possible in KNIME as this is not really what KNIME is supposed to do. It might be possible to create something like this but I guess it is quite a bit of effort. I would say your best bet is to go to the KNIME forums and ask there how one should approach this (unfortunately, I do not have a solution at hand right now). Hope this helps anyways.

Thank you for the comment. If you mean the workflow group within the workspace, you cannot add nodes there. The workspace holds either folders (called workflow groups) or workflows themselves. A node is always within a workflow. But what you can do and what you probably have seen is something like a data folder that holds the source files. To do that, right click on the workspace and select "New Workflow Group..." - name this "data" Then you can right-click on that newly created folder and select "copy location" -> "local path". This will copy the location on your system to the clipboard. Open a file explorer (e. g. Windows Explorer) and paste this copied address in - voilà, you're now in that folder. Now you can copy paste any file into that folder using standard file copying processes (like CTRL+C and CTRL+V) on your local machine. If you click the refresh button in the KNIME explorer, you will see the files there. Let me know, if this helps.

Thank you for the question. A little bit hard to say without knowing the data or seeing the workflow. But I found a discussion on the KNIME forums, that may help you: forum.knime.com/t/desicion-tree-predictor-predicts-missing-values/4513/9

Thank you for the kind words, I really am happy that I can help. I know it's a little bit of s hassle but could eventually send me an email to Phil at procurementzen dot com ? I will make sure you get access to everything.

Thanks for your comment. You can find the complete workflow incl the source files here: hub.knime.com/-/spaces/-/~AcGhvMziu4hdT4si/current-state/ I have updated the description of the video accordingly.

Thank you for the comment. The question is a little bit what it is you want to take a screenshot of. Web- / Browser content can be done e.g. with Selenium Nodes (premium add on but very affordable) or the Screenshot node from AF Utility Nodes. I don't understand though what you mean by save it to an Excel file. Do you want to integrate an image format (like jpg, png etc) in your spreadsheet file?

Thank you for the comment, Arjit. Yes. Once you have opened your worklfow, take the second to last icon (the one that reads "Opew the settings dialog for the workflow editor") or alternatively press CTRL+ALT+SHIFT+X - this will open the Workflow Editor Settings which are relevant only for this workflow. Uncheck the box at the bottom that reads ""Curved Connections" - now they should be straight. By the way, send me an email to phil@procurementzen.com and I send you the voucher code for 100% discount voucher for the KNIME press ebooks, in case you're interested.

Thank you for your comment. Unfortunately I don't have any experience with Keras, so I can't really help here

Hi Higinio ... have a look at this one (installation under Windows): ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-S0KOxR1XKEk.html - unfortunately I have no video for installing under Linux

Thanks for your comment. What exactly do you have problems with?

My Problem is (........number of rows.)@@procurementzen drive.google.com/file/d/1fxE8gl1iewqj9ZmS48XABXbtCANUOHw8/view?usp=sharing

My Problem is (...............the number of rows.) drive.google.com/file/d/1fxE8gl1iewqj9ZmS48XABXbtCANUOHw8/view?usp=drive_link@@procurementzen

@@procurementzen My Problem is (...............the number of rows.) drive.google.com/file/d/1fxE8gl1iewqj9ZmS48XABXbtCANUOHw8/view?usp=drive_link @procurementzen

My Problem is (...............the number of rows.) drive.google.com/file/d/1fxE8gl1iewqj9ZmS48XABXbtCANUOHw8/view?usp=drive_link @procurementzen

Dear Saga, thank you very much for your kind words and your comment. You can find the Excel data I am using over at my public space in the KNIME hub. If you go to hub.knime.com/kowisoft you should find my workflows (which include the files in the respective data folders) on the hub. If you can't find them, just let me know, and I make sure to re-up them to make them available to you.

@@procurementzen Hi, I'm sorry but I can't find the file with buyer names all I see in your public space in KNIME hub are these resources for this case: PO Example Data.xlsx --> the first file you use in the video, right ? material-fields.xlsx --> idk why this is useful yet pmt-catalogue.xlsx--> idk why is useful yet result-PMT-overview.xlsx --> what seems to be the result of combination ? idk I haven't reached that step Could you please re-upload the buyer ID file or let me know where to find it? because they seem to have different names than in your video :/ Sorry to bother you with that, I have a test soon on this and our teacher recommended this video of yours !! Your lessons are really nice so far :)

Thank you @Violette - I have updated the file in my public space on the KNIME hub: hub.knime.com/kowisoft/spaces/Public/latest/Digitization%20For%20Procurement%20Pros/Exercises/Module%201/vendor%20reporting%20-%20solution~AcGhvMziu4hdT4si Now all Excel Reader and Excel Writer Nodes point to the local data folder, which comes together with the workflow. And I feel honored, that some teachers recommend my videos for learning. Hope they provide some insights :)

sure: the top output port gives you the completed pivot table (the combination of groups and pivots) The middle output port gives you only the groups (wihtout the pivots) And the bottom output port gives you just the pivots (without the groups) You can evaluate each one of them by right-clicking on the executed Pivoting Node and instead of selecting the Pivot Table entry at the bottom of the context menu, select one of the other 2 items. Hope that helps and thanks a lot for your comment!

@@procurementzen thank you for replying

It is on my public space on the KNIME Community Hub. You can find it here (the completed solution INCL the data): hub.knime.com/-/spaces/-/~AcGhvMziu4hdT4si/current-state/ Let me know, if this helps.

I opened the folder "exercise" and the data I saw was 4 in number, I couldn't find exactly the data you used with 5 columns and i didn't see the exact dataset and also the buyer data was not in the folder as well

Probably the link is not working correctly. If you land in the Exercises folder, then you need to go to Module 1 > vendor reporting solution and download that file. It has the source files included in the workflows's data area itself. Let me know, if that helps.