Thank You. I'm brand new to Knime and I learned more from you in 20 minutes than hours of frustration trying to figure out how to get off the ground. A lot of "beginner" guides just blast through the "begin" part.
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 😃
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 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 very much for the detailed and clear explaination of the steps..you know exactly how what to show..also just FYI..Ihave been playing around with data analytics, ML/AI and ofice automation for 3 years , and only now I came across this fantastic OS super duper office automation SW...! its superb..@ and thansk again!
@@bytesandbudgets 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!!
6:41 When I right-clicked, I couldn’t find the File Table option. It was actually under Right Click > Open Output Port > File Table. Thanks for the video.
Yes, that's true, thank you for pointing this out. Since this video was created, the interface has changed to the new KNIME v5 and some things are different there.
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 😏
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.
Hey. I am using KNIME to build decision tree classifier. I have two datasets, training and unknown which I have connected to Decision Tree Learner and Decision Tree Predictor respectively. However, the scorer shows an error of 'There were missing values in the reference or in the prediction class column'. There are no missing values in the dataset, I have treated them all. Could you help me make sense of this? Thanks!
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 all the info you provide. A quick question: On min 6:28 , Your Node shows Excel Reader (4:1). Mine cannot keep from showing 0:1 not matter what I do. Based on some posts on the forum I even have reinstalled my Knime app and nothing changed. Any ideas?
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.
How can you add the Excel reader directly into the Workflow group? so instead of having a workflow that reads that file, I want to put the file reader in the folder. I saw that this is possible with the default exercises in Knime.
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 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?
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!
Hello Sir.. could you please suggest the Knime flow to rename the File as per month basis ex if am running flow on Oct flow should run and save file in the Name of Report 1 , same nov Report 2 similar for all months
Thanks a lot for your question @madhusudhan - I have created a quick video for you, which you can find here: th-cam.com/video/v_ZTpRX-djM/w-d-xo.html Let me know, if this helps.
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.
Hello team, I am looking for the flow which helps us for language translate as per the below with Create table with Column Translator Value column and with expression under Rule engine of true condition - //$Translator Value$ = "ar" //$Translator Value$ => "en" //$Translator Value$ = "en" //$Translator Value$ => "ar" but this is not translating any language. Could you please assist on the correct flow for my concern
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.
I'm unable to figure out to make my connections straight. They always come out curved. Can you point me to the place where I can configure straight arrows instead of curved ones. Thanks.
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.
Thanks a lot for your comment. You can find the whole workflow on the KNIME Community Hub: hub.knime.com/s/AcGhvMziu4hdT4si This also includes the Excel files which are stored (together with the workflow) in this workflow's data area. Please let me know, if you have any questions, I am always happy to help.
Hi Higinio ... have a look at this one (installation under Windows): th-cam.com/video/S0KOxR1XKEk/w-d-xo.html - unfortunately I have no video for installing under Linux
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.
Plz Help Me, Solving The Question. Question 1 Create a KNIME workflow where you read the provided autos data set. Exlcude the columns 'normilized' and 'bore'. Filter the rows on the price column and keep only instances describing cars that are less than $10,000. Write the file out to csv and report back the number of rows.
@@bytesandbudgets My Problem is (...............the number of rows.) drive.google.com/file/d/1fxE8gl1iewqj9ZmS48XABXbtCANUOHw8/view?usp=drive_link @procurementzen
Hello sir, I have really enjoyed your session so far. I would really want to complete this entire course. But at the same time I want to know if you provide the excel data that you are using so that I can practice along with you. I subscribed to your platform but could'nt find the excel data there. If you can, please let me know how you I can access them. Thanks
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.
@@bytesandbudgets 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 :)
KNIME was judiciously explained in this TH-cam webinar. A big THANK YOU to the Facilitator
Sir... you are straight to the point, cutting all the clutter... much respect from Pakistan...
Thank You. I'm brand new to Knime and I learned more from you in 20 minutes than hours of frustration trying to figure out how to get off the ground. A lot of "beginner" guides just blast through the "begin" part.
Thanks a lot for the feedback and I really appreciate your feedback. New videos will be coming soon 😉
Perfect! Got my work done correctly and early using KNIME and your crash course. Thanks!!
Thanks 🙏 Great, that this helped you
Hello! I'm working on learning this tool to improve my chances at a new job that uses this tool. Your demonstrations are very helpful. thank you!
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 this tutorial
Thank you, as easy to understand as you explain, good video, we follow you from Guatemala. 👍🏻
Awesome, glad you like it and happy that even on the opposite side of the globe this helps 😉
Thank you Sir! As a beginner, you explain this very well. Would like to suggest to upload the sample excel file though :)
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 😃
VERY INFORMATIVE AND CLEAR EXPLANITION
Thank you ,glad you like it
Very clear. Thanks for this bro😁💪
Awesome, really glad you like it! Just ping me here via comments, if anything is unclear. I'm happy to support you.
This detailed explanation is awesome!
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.
That was a brilliant way of explanation. Thanks
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 very much for the detailed and clear explaination of the steps..you know exactly how what to show..also just FYI..Ihave been playing around with data analytics, ML/AI and ofice automation for 3 years , and only now I came across this fantastic OS super duper office automation SW...! its superb..@ and thansk again!
Great that you like it. It has definitely changed my way of dealing with data and approaching "programming" (there, I said it 😄)
Excellent
Thank you 😃
fantastic vedio keep it up❤❤
Thank you a lot Majid, glad you like it. Let me know, if anything is unclear or if I can help
Excellent!!!
thanks a lot for the comment, great that you like it 😀
@@bytesandbudgets 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!!
6:41 When I right-clicked, I couldn’t find the File Table option. It was actually under Right Click > Open Output Port > File Table.
Thanks for the video.
Yes, that's true, thank you for pointing this out. Since this video was created, the interface has changed to the new KNIME v5 and some things are different there.
Thank you!! Great video 😀
Thanks a lot for your nice words, makes me smile 😀 Happy to share the knowledge
Thank you from morocco🙏👍🌹
Good performance.👍
Thanks a lot, Salim ... really appreciate your kind words. :) Let me know, if there are any questions.
Extremely helpful!
Many thanks :)
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
Thank you for this very useful video!
Thank you for your kind words, happy that you like it.
This has been really helpful. Thank you so much!
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. 😀
Good stuff!
Thanks a lot. Glad that it is of help. Hope the other episodes benefit you as well :)
Good, keep it up 🤘🤘
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 😏
basically running sql statement graphically ?
Nice and clear. Thank You!
Thank you for the feedback, Tomasz 🙏 I hoped that it came across in an understandable way 😀👍
@@bytesandbudgets Yes it did 🥳
Hey, can you declare global variables and set the metanodes to repeat for each data row? Thanks!
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.
Thank you.
more than welcome, hope I could share a bit of knowledge 😀
excellent explanation , thank you !
Thank you, dmmmm :) Glad that it helped.
excellent
sweet, glad that you liked it 😀 sharing is caring
Great video. Is is possible to combine several different nodes? Rather than performing tasks one by one, we include multiple actions in a single node.
Hey. I am using KNIME to build decision tree classifier. I have two datasets, training and unknown which I have connected to Decision Tree Learner and Decision Tree Predictor respectively. However, the scorer shows an error of 'There were missing values in the reference or in the prediction class column'. There are no missing values in the dataset, I have treated them all. Could you help me make sense of this? Thanks!
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 all the info you provide. A quick question: On min 6:28 , Your Node shows Excel Reader (4:1). Mine cannot keep from showing 0:1 not matter what I do. Based on some posts on the forum I even have reinstalled my Knime app and nothing changed. Any ideas?
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.
Thanks.
Thank you for your feedback, appreciate it! 🙏
How can you add the Excel reader directly into the Workflow group? so instead of having a workflow that reads that file, I want to put the file reader in the folder. I saw that this is possible with the default exercises in Knime.
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.
Hello Zen, may I ask if you've tried already automating a screenshot lets say a PDF then save it in excel file?
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?
hey, I keep getting 3 output nodes in joiner, can you help me out?
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!
@@bytesandbudgets thank you for replying
Hello Sir.. could you please suggest the Knime flow to rename the File as per month basis ex if am running flow on Oct flow should run and save file in the Name of Report 1 , same nov Report 2 similar for all months
Thanks a lot for your question @madhusudhan - I have created a quick video for you, which you can find here: th-cam.com/video/v_ZTpRX-djM/w-d-xo.html
Let me know, if this helps.
@@bytesandbudgets thank you so much sir
@@bytesandbudgets , thank you so much sir.. it is really helpfull :)
Great that I could be of help
where is the excel file which is used in the video
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.
I have problem when run the keras learning network
The error appear and stop the implementation.
I can’t know the reason, can you help me?
Thank you for your comment. Unfortunately I don't have any experience with Keras, so I can't really help here
Hello team, I am looking for the flow which helps us for language translate as per the below with Create table with Column Translator Value column and with expression under Rule engine of true condition -
//$Translator Value$ = "ar"
//$Translator Value$ => "en"
//$Translator Value$ = "en"
//$Translator Value$ => "ar"
but this is not translating any language. Could you please assist on the correct flow for my concern
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.
I'm unable to figure out to make my connections straight. They always come out curved. Can you point me to the place where I can configure straight arrows instead of curved ones. Thanks.
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.
where can i find the excel files?
Thanks a lot for your comment. You can find the whole workflow on the KNIME Community Hub: hub.knime.com/s/AcGhvMziu4hdT4si
This also includes the Excel files which are stored (together with the workflow) in this workflow's data area.
Please let me know, if you have any questions, I am always happy to help.
Which of your videos it explains how to install KNIME in Windows and Linux?
Hi Higinio ... have a look at this one (installation under Windows): th-cam.com/video/S0KOxR1XKEk/w-d-xo.html - unfortunately I have no video for installing under Linux
Ohh! Mike Shinoda changed his profession .. :D
😂 Thank you, although I am not a good guitar player 😉
Great content and helpful. I am trying to login on you Digitization for Procurement website, but for some reason I cannot find the register button.
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.
Plz Help Me, Solving The Question.
Question 1
Create a KNIME workflow where you read the provided autos data set. Exlcude the columns 'normilized' and 'bore'. Filter the rows on the price column and keep only instances describing cars that are less than $10,000. Write the file out to csv and report back the number of rows.
Thanks for your comment. What exactly do you have problems with?
My Problem is (........number of rows.)@@bytesandbudgets
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@@bytesandbudgets
@@bytesandbudgets 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
Hey Man thanks for posting this. Do you do private 1:1 training lessons?
Sure. I would suggest you contact me via phil@procurementzen.com
Hello sir, I have really enjoyed your session so far. I would really want to complete this entire course. But at the same time I want to know if you provide the excel data that you are using so that I can practice along with you. I subscribed to your platform but could'nt find the excel data there. If you can, please let me know how you I can access them. Thanks
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.
@@bytesandbudgets 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 :)