Learn about KNIME Analytics Platform in thoughtfully created, detailed videos designed to help you gain expertise and expand your knowledge!
Check out my new companion site knime.tips! On this site I publish articles, thoughts and longer form tutorials to go with these videos.
I'm a data professional who loves using KNIME. This powerful free tool is a fantastic resource with a bit of a learning curve. That's where this channel comes in!
Hi there! I appreciate how well you explain things. I have a question about my data. How can I determine which features are the most important? I want to know which columns have the most value so I can use them instead of unnecessary ones. Thank you.
Have you stopped creating videos? Your content is the best one about knime on RU-vid 😅 Maybe instead of explaining simple modules you should use an example for video about a real problem and using that you could explain the theory!❤️
Hey @LUDOVICOPAPALIA, thank you for the kind words and the insightful comment! I certainly want to create more robust and useful video content. I have a few projects that would be good candidates to show workflow development. Even with the rise of AI, I still feel as though the vast majority of our workflows follow traditional approaches that would be helpful to see. Again, thank you watching, and thank you for the comment!
Hi friend. It's possible to reference a created column on the next (down sequence formula)? Example: I create the first column named "column 1" and write the formula. Then I want to create a second column, but that second column depends on the result of the first column. When I click on the + column, the new columns don't appear. So I don't know how to reuse to chain effect. Can I do this using the same node or I have to continue the effect using another "Column Expression node"?
Hi @Manoj .M thanks for reaching out! I don't have anything written up yet, but in the meantime here are a couple of forum resources that may serve to answer your questions. forum.knime.com/t/cluster-with-binary-categorical-and-numerical-variables/5902/6 forum.knime.com/t/clustering-using-both-numerical-and-categorical-data-kmedoids/9301/3 www.knime.com/sites/default/files/inline-images/knime_seventechniquesdatadimreduction.pdf
@@manoj.m3813 Do you have an example workflow that you could upload to the KNIME Hub? Once you do so, please put the link in the comments and I can take a look.
Hi Alexander, KNIME Analytics Platform is free and a desktop app. KNIME Server is the paid enterprise oriented version. Visit www.knime.com/downloads to get your free copy.
That's fantastic Rahmat! Best wishes and feel free to reach out with any questions. Check out these resources I have a lot of tutorial articles on both: knime.tips medium.com/low-code-for-advanced-data-science/low-code-for-advanced-data-science-a-new-journal-8bebee7ed619
Hi Bak. Uploaded where? I can't speak to how secure or not external data connections are within the platform itself, but it does use SSL and authentication (for SharePoint as an example). I am happy to clarify for you.
Hi threej4pop. I'm sorry to hear that! Maybe I should-do this video? KNIME is a platform that lets you ingest, clean and manipulate your data. Additionally, it lets you define and run stats, ML, Deep Learning and AI models while integrating Python, R, JAVA and more in a single analytics space. You can then push your processed data to flat files, cloud storage, DBs and more. I hope this helps!
Hi Hassan! To an extend yes, but that's really enabled through the paid platform, KNIME Server. You can still make dashboards that other KNIME Analytics Platform users can interact with inside of your workflow, but those are not widely distributed in the way I think you are asking. Additionally, you can wrangle your data in KNIME and push it out to something like Tableau or PowerBI.
Great video! Is there a way we can also remove duplicate / dups data in the parent table and substitute that unique values in the child table using KNIME? For example, if there is data redundant data of customers with a unique key present in a CSV file, where the requirement is to keep one customer record, based on the record kept, substitute its key to all the children's tables (let's say in this case CustomerHistory table). CustID FName LName 101 Rick Smith 102 Rick Smith 103 Rick Smith 201 June Robert 202 June Robert 301 April Limestone 302 John Jones 303 John Jones 404 John Jones 501 John Jones 601 August Beautiful Child table CustomerHistory table CustHistID CustID 1001 101 1002 101 1003 102 1004 103 1005 103 1006 103 1007 201 1008 202 1009 202 1010 301 1011 302 1012 303 1013 404 1014 501 1015 601 1017 404 1018 301 1019 303 1020 404 Expected results after correction should be Customer table CustID FName LName 101 Rick Smith 201 June Robert 301 April Limestone 302 John Jones 601 August Beautiful Child table CustomerHistory table CustHistID CustID 1001 101 1002 101 1003 101 1004 101 1005 101 1006 101 1007 201 1008 201 1009 201 1010 301 1011 302 1012 303 1013 303 1014 301 1015 601 1017 303 1018 301 1019 303 1020 303 Help would be greatly appreciated!
Hey @mshazad73 email me some example data at info@knime.tips and I will see what I can put together. If I'm understanding your ask correctly, off the top of my head I'm thinking you could just concat the two tables and GroupBy taking the first or last value as the aggregation method (depending). I would definitely like to see a flat file so I could build a workflow example for you. Looking forward to your email!
Hello, thanks for sharing your knowledge! it is hard to find knime stuff, but you have a very good teaching skills with a great video format! i have a silly question about knime running in macOS. i saw you double click over a node to change its name, but when i do it, it opens the text format in other desktop. it is very wierd and i dont realized yet how to get rid of this. do you might know why and how to do as you did in your video? thanks! keep the good work!
Hey @Falinho that's strange. I have not had that particular issue yet with renaming nodes - though I've had struggles at times with clicking into the node text to annotate on MacOS. I would recommend updating if you can and see if it's still an issue. Do you have KNIME in full screen? That could possibly be an issue as well.
Yes I do, and I'm working on new video content. I just rolled out knime.tips and am adding these videos to the site with long-form articles and I hope to have some companion workflows that go with the video.
Hey v sr, I will do my best! I write a lot of tutorial articles on my website knime.tips and through the KNIME Low Code Journal at medium.com/low-code-for-advanced-data-science/low-code-for-advanced-data-science-a-new-journal-8bebee7ed619.
Hi Emperor Group! That's always the goal. I make these videos in my free time and wish I could produce more volume with faster turnaround! In the meantime I write a lot for my website knime.tips and the KNIME Low Code Journal at medium.com/low-code-for-advanced-data-science/low-code-for-advanced-data-science-a-new-journal-8bebee7ed619
I have a series on the Expression nodes I am about to put together. Script written, workflow done. I just have to record and edit and upload! Stay tuned! Thank you for all your patience. Checkout knime.tips in the meantime!
Hi Raul, thank you for the comment! I just finished this video on the String to Date&Time node, ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hXecMGvrJFo.html. Enjoy!
Yes! R integrates really well into KNIME on both Mac and PC. I primarily use it for creating visuals with ggplot2 , but you can use R for a whole lot more in KNIME. Did you want to see something specific?