KNIME Cell Replacer
3:50
Жыл бұрын
KNIME - split rows by number
5:00
2 жыл бұрын
Knime Best Practices - Flow Variables
18:41
KNIME: What should I do? You decide!
1:36
Knime Crash Course: The KNIME Forum
5:58
Nodepit
3:31
2 жыл бұрын
Knime Crash Course: The KNIME Hub
5:00
Knime Crash Course: Sorter Node
4:44
Пікірлер
@rajeshrawal1681
@rajeshrawal1681 5 күн бұрын
please make a new video how to use R snippet
@procurementzen
@procurementzen 5 күн бұрын
thank you for the comment, but unfortunately I do not know R, and hence cannot really make a tutorial about that.
@kennedydafeakeh8573
@kennedydafeakeh8573 17 күн бұрын
Thanks.
@procurementzen
@procurementzen 15 күн бұрын
Thank you for your feedback, appreciate it! 🙏
@RocíoQuinteiroVillanueva
@RocíoQuinteiroVillanueva 21 күн бұрын
Thanks for your Job :)
@procurementzen
@procurementzen 15 күн бұрын
Thank you for the comment 🙏 you're most welcome 😁
@All-Vibes-LoFi
@All-Vibes-LoFi 28 күн бұрын
Perfect! Got my work done correctly and early using KNIME and your crash course. Thanks!!
@procurementzen
@procurementzen 15 күн бұрын
Thanks 🙏 Great, that this helped you
@FathimaThanseeha-i2s
@FathimaThanseeha-i2s Ай бұрын
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.
@procurementzen
@procurementzen Ай бұрын
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.
@maheshj2981
@maheshj2981 2 ай бұрын
amazing training videos you Phil, thanks for this
@procurementzen
@procurementzen 2 ай бұрын
Awesome, great that you liked it.
@maheshj2981
@maheshj2981 2 ай бұрын
#knime book voucher please
@procurementzen
@procurementzen 2 ай бұрын
Here you go: PKN-2024 Valid for 2024
@brianbarreto2978
@brianbarreto2978 2 ай бұрын
therea are any selenium node free? i havent money to buy the license.
@procurementzen
@procurementzen 2 ай бұрын
Thanks for the comment, Brian. No, not as I know. They do have a 14 days (or so trial). One other option (but not exactly the same) are the AF Utility Nodes: hub.knime.com/anotherfrauduser/extensions/org.anotherfraud.excel.feature/latest They contain some browser / selenium features as well. Hope that helps.
@DDSPAD
@DDSPAD 3 ай бұрын
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
@procurementzen
@procurementzen 3 ай бұрын
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
@DDSPAD 3 ай бұрын
@@procurementzen Thnx a lot!
@gab137
@gab137 3 ай бұрын
Thank you!! Great video 😀
@procurementzen
@procurementzen 3 ай бұрын
Thanks a lot for your nice words, makes me smile 😀 Happy to share the knowledge
@khushboojain860
@khushboojain860 3 ай бұрын
where is the excel file which is used in the video
@procurementzen
@procurementzen 3 ай бұрын
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.
@ajit555db
@ajit555db 3 ай бұрын
Learnt about configuration in Components, thanks.
@procurementzen
@procurementzen 3 ай бұрын
great 😄 they are a great way of making KNIME accessible to people who don't know (or don't want to know) all the ins and outs of it. Basically it's 'click here - make your selection - execute' 👍
@GavinVaz-i1h
@GavinVaz-i1h 3 ай бұрын
Hello Sir, will you be coming up with a detailed series on the new version?
@procurementzen
@procurementzen 3 ай бұрын
thanks a lot for the comment. Yes, I think I will do a walkthrough video very soon. Some things have changed and some things (as of now) seem to be gone so it would be maybe interesting to see, where you can find 'stuff' in the new frontend.
@gerdpeters4132
@gerdpeters4132 3 ай бұрын
Finally I am able to comment on this: Impressive showcase and enertaining presentation. As always, Phil's able to transport information and knowledge: This time in sweet chunks of Barabara's Rhubarb Cake. Enjoy!
@procurementzen
@procurementzen 3 ай бұрын
thanks a lot, I really appreciate this. And my hunger for cake is always increasing 🍰😉
@SabineKowalski-pt9qf
@SabineKowalski-pt9qf 4 ай бұрын
😂 Love it.
@procurementzen
@procurementzen 3 ай бұрын
sweet, my dear, thank you ♥
@DonFrido13
@DonFrido13 4 ай бұрын
Awesome video! Fun and educational. Just waiting to see you dance!
@procurementzen
@procurementzen 4 ай бұрын
Thanks a lot - one step closer to it 😁
@LowCodeAIForTheWin-fx2bo
@LowCodeAIForTheWin-fx2bo 4 ай бұрын
🖐love it
@procurementzen
@procurementzen 4 ай бұрын
Thanks a lot for the kind words - sometimes these ideas jump out of nowhere and then we have some fun stuff like this
@Marie-r7x
@Marie-r7x 4 ай бұрын
Amazing how fast & fun data processing can be!
@procurementzen
@procurementzen 4 ай бұрын
thanks a lot for the comment. fast, fun 😀, sweet 🍰, barbaric , beardy 🧔🏽 - who ever thought this could relate to KNIME, right?
@KamilKurowski-pp6ny
@KamilKurowski-pp6ny 4 ай бұрын
Wohoo, seems I'm a Jedi then :D Great summary!
@procurementzen
@procurementzen 4 ай бұрын
Hey Kamil, thanks a lot for the comment ❤ Could you ever imagine that a 'piece of cake' 🍰or at least the sound of it 🎵 can make you a KNIME Jedi?
@oliverlewis6126
@oliverlewis6126 4 ай бұрын
Love that Philipp, creative, engaging and informative!
@procurementzen
@procurementzen 4 ай бұрын
Thanks a lot, Oliver. Glad that you like it, it was also a lot of fun creating it 😉 And the hunger for lots of cake has definitely increased 🍰
@MarkBanham-zl5ec
@MarkBanham-zl5ec 4 ай бұрын
V cool - love it. A big slice of that cake for me please
@procurementzen
@procurementzen 4 ай бұрын
Thanks a lot @Mark - not sure, how we can get the cake over to you in the real world, but I think about a virtual way (at least 😉)
@tobiashornig6294
@tobiashornig6294 4 ай бұрын
Ah, Philipp is always in combining different media, ideas, and content to great something bigger. I really, really like it
@procurementzen
@procurementzen 4 ай бұрын
and did you ever think you could combine data 🖥and rhubarb cake🍰
@fernandomartincaneque
@fernandomartincaneque 4 ай бұрын
Thanks a lot for your veru helpful videos!!!
@procurementzen
@procurementzen 4 ай бұрын
Great that you experience them as helpful
@suryaabhishek8484
@suryaabhishek8484 4 ай бұрын
Hi! How can I subtract one column from another?
@procurementzen
@procurementzen 4 ай бұрын
Thank you for the comment. If both are numerical columns, you could use a Math Formula Node and either overwrite an existing column OR append the result as a new column. Hope that helps.
@fernandomartincaneque
@fernandomartincaneque 4 ай бұрын
Excellent!!!
@procurementzen
@procurementzen 4 ай бұрын
thanks a lot for the comment, great that you like it 😀
@fernandomartincaneque
@fernandomartincaneque 4 ай бұрын
@@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!!
@kashish9285
@kashish9285 4 ай бұрын
Hey, can you declare global variables and set the metanodes to repeat for each data row? Thanks!
@procurementzen
@procurementzen 4 ай бұрын
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.
@madhusudhan5384
@madhusudhan5384 4 ай бұрын
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
@procurementzen
@procurementzen 4 ай бұрын
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.
@jbisme8179
@jbisme8179 4 ай бұрын
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.
@procurementzen
@procurementzen 4 ай бұрын
Thanks a lot for the feedback and I really appreciate your feedback. New videos will be coming soon 😉
@matthewmays8109
@matthewmays8109 5 ай бұрын
Hi Zen, do you have a video on applying the same conditional formatting to multiple sheets in a file?
@procurementzen
@procurementzen 4 ай бұрын
Hello Matthew, sorry, for not getting back to you earlier (was on vacation ;) - I don't have a workflow at hand but the initial idea on how to approach this would be to loop through the sheets. Let me know, if you want to hear more about this and I'll do a video where I loop over several sheets and apply the same formatting everywhere (like in 'monthly sheets')
@Isekai-Ojisan
@Isekai-Ojisan 6 ай бұрын
Thank you Sir! As a beginner, you explain this very well. Would like to suggest to upload the sample excel file though :)
@procurementzen
@procurementzen 6 ай бұрын
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 😃
@jamesturner4683
@jamesturner4683 6 ай бұрын
Thanks for the video. I can see if you're not too familiar with Excel, ChatGPT could be quite useful for suggesting formulas/methods. However, if you're already an experienced Excel user, it might be faster to just clean the data yourself rather than to spend time describing what you want done. For example, at 11:53, if this was a one off task, it would be faster to hard code column K then use the text to columns feature and use a space as the delimiter to separate the city from the country rather than spend time describing the problem and then pasting in the formulas. If you were regularly getting an export like you've demonstrated and it was always in that particular format, then getting ChatGPT to help create cleaning tool might be useful. One of the data clean up tasks I need to do is to copy/paste the list of executive team members from various corporate websites (i.e. Bank of Bahrain & Kuwait, Bendura Bank, Bahrain Islamic Bank etc) into Excel then arrange the pasted data into nice neat columns showing first name, any middle names, last name and the job title. The pasted-in text always is in a completely different structure from each corporate website and there is normally a lot of superfluous information too. I'd love to be proved wrong but after writing a different request for each different collection of text belonging to a corporate website then checking the results then refining the prompt, I think I'd be faster just doing it myself manually.
@procurementzen
@procurementzen 6 ай бұрын
Thanks. As always this might be one option, there are surely many others. I guess people use what they prefer.
@jsarkr
@jsarkr 6 ай бұрын
Thats a great explanation!! Since we are concatenating multiple files would it be possible to include a column in the concatenated file that shows from which files the records has come from? this would help identify the source file if there are any issues in the concatenated records.
@procurementzen
@procurementzen 6 ай бұрын
Absolutely possible 😀 If you import files through an Excel Reader Node you need to go to the 'Advanced' tab. There in the 'File and Sheet' section (the one at the very top) you will see an option to 'Append file path column'. Check that and an additional column with your file path will be added at the end of your table. Works for both, single file imports as well as if you choose the 'Files in folder' option in the Excel Reader Node. Let me know, if that helped 🙃
@mihnearazvan1
@mihnearazvan1 7 ай бұрын
Thanks for the explanations! What if I want to combine several files with different column names?
@procurementzen
@procurementzen 7 ай бұрын
Thank you for the feedback. Glad you like it. If you want to do it VLOOKUP style (like in Excel) you probably want to use the Joiner Node (see this video: kzbin.info/www/bejne/l57QfpWpgt6be6M) Otherwise you can still use the Concatenate Node but must accept that for the non-equal columns (so basically the ones that are in one table but not the other) you will have missing values. Hope this helps.
@CYRUT2
@CYRUT2 7 ай бұрын
Great content. New to Knime. Any chance of maybe creating a video for this workflow describing the use of those unpublished extensions and getting all of those nodes working from a new install. I bet it is easy and for a new user like me; highly valuable.
@procurementzen
@procurementzen 7 ай бұрын
Thank you for the feedback. If you need to discover how to install extensions, you can have a look here (video from KNIME themselves): kzbin.info/www/bejne/paGqdHubjL-SppI The Selenium Nodes themselves are premium ones, but they come with a trial period. Additionally, there is this great article on how to use a different set of nodes (also an extension but a free one) you can find on LinkedIn: www.linkedin.com/pulse/web-scrapping-knime-%2525C3%2525A1ngel-molina-laguna-ypnwf/?trackingId=bue68LWGJMaMuQ5wtrVj8A%3D%3D Let me know, if this helped.
@0611lucky
@0611lucky 7 ай бұрын
Ohh! Mike Shinoda changed his profession .. :D
@procurementzen
@procurementzen 7 ай бұрын
😂 Thank you, although I am not a good guitar player 😉
@MuhammadSumonChowdhury
@MuhammadSumonChowdhury 7 ай бұрын
My Problem is (...............the number of rows.) drive.google.com/file/d/1fxE8gl1iewqj9ZmS48XABXbtCANUOHw8/view?usp=drive_link @procurementzen
@MuhammadSumonChowdhury
@MuhammadSumonChowdhury 7 ай бұрын
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.
@procurementzen
@procurementzen 7 ай бұрын
Thanks for your comment. What exactly do you have problems with?
@MuhammadSumonChowdhury
@MuhammadSumonChowdhury 7 ай бұрын
My Problem is (........number of rows.)@@procurementzen drive.google.com/file/d/1fxE8gl1iewqj9ZmS48XABXbtCANUOHw8/view?usp=sharing
@MuhammadSumonChowdhury
@MuhammadSumonChowdhury 7 ай бұрын
My Problem is (...............the number of rows.) drive.google.com/file/d/1fxE8gl1iewqj9ZmS48XABXbtCANUOHw8/view?usp=drive_link@@procurementzen
@MuhammadSumonChowdhury
@MuhammadSumonChowdhury 7 ай бұрын
@@procurementzen My Problem is (...............the number of rows.) drive.google.com/file/d/1fxE8gl1iewqj9ZmS48XABXbtCANUOHw8/view?usp=drive_link @procurementzen
@MuhammadSumonChowdhury
@MuhammadSumonChowdhury 7 ай бұрын
My Problem is (...............the number of rows.) drive.google.com/file/d/1fxE8gl1iewqj9ZmS48XABXbtCANUOHw8/view?usp=drive_link @procurementzen
@shaiksamdani5142
@shaiksamdani5142 8 ай бұрын
Great session 👍🏻 and thanks for the voucher help I appreciate it
@procurementzen
@procurementzen 7 ай бұрын
great that you like it
@yesthemess
@yesthemess 8 ай бұрын
Sir... you are straight to the point, cutting all the clutter... much respect from Pakistan...
@GiriPrasath.D
@GiriPrasath.D 8 ай бұрын
Interesting about the knime, eager to know more about it.
@procurementzen
@procurementzen 8 ай бұрын
Thank you for the comment @Prasath - really glad you like it. If you have any questions, please post them in the comments. I try to answer everything 👍😃
@GiriPrasath.D
@GiriPrasath.D 8 ай бұрын
i think the knime was removed the website you showing in the videos . but i learning the basics of knime from you, very interesting tool knime, it was perfect for no/low code app.
@procurementzen
@procurementzen 8 ай бұрын
Yeah, I couldn't locate the original page either. But here's pretty much exactly the same page on medium: medium.com/low-code-for-advanced-data-science/data-exploration-in-66daysofdata-with-knime-a0092b78b87f Let me know, if that helps!
@GiriPrasath.D
@GiriPrasath.D 8 ай бұрын
@@procurementzen Thanks 😊
@LoneWolfMLBB
@LoneWolfMLBB 8 ай бұрын
I want to change the color of the line in a line plot, is there any way to do that
@procurementzen
@procurementzen 8 ай бұрын
thank you for the comment. In the Line Plot (JavaScript) Node it is unfortunately not possible. But what you could try is to use the Plotly Line Plot which you need to install through an extension.
@LoneWolfMLBB
@LoneWolfMLBB 8 ай бұрын
Thanks for replying! I tried plotly too yesterday but it tells me to sign up with an organisation email. I entered my email and it ended up showing a failed sign up@@procurementzen
@GiriPrasath.D
@GiriPrasath.D 8 ай бұрын
Currently watching your playlist of knime , i will accept the #66days data challenge.
@procurementzen
@procurementzen 8 ай бұрын
Great - I really think it's worth the time as you learn a lot of interesting things ;)
@RakeshSolanki-gw1cq
@RakeshSolanki-gw1cq 8 ай бұрын
Hey Friend, i am new to Knime and curious to learn more on it. I need some help on creating a Database. I have 50 Excel files placed in a folder and it can be 300 Excel files soon, in this excel files top 10 rows are useless and the header starts from 11th row and i need to create a Database as a Tableau Extract or hypr file which can enable this database to create visualization in Tableau. Hope you understand my query and do reach out for any questions. You are doing a great work 😇
@procurementzen
@procurementzen 8 ай бұрын
Thank you for the kind words, Rakesh. I would suggest that you use the setting "Files in Folder" in the Excel Reader. This reads all Excel files in the specified folder. You can also use filters, e. g. read only files that begin with "ABC" etc. The only requirement is that the Excel files follow the same structure, so e. g. as you mentioned the header always starts in 11th row etc. KNIME then concatenates these files together at its output port and it doesn't matter if it's 5, 50 or 500 (except for the time it takes). Going on from there you can manipulate / transform your data and then e. g. write to an existing DB. Let m know, if this helped.
@RakeshSolanki-gw1cq
@RakeshSolanki-gw1cq 8 ай бұрын
Thank you so much@@procurementzen I will try these steps and let you know if this works.
@turystycznytester3569
@turystycznytester3569 9 ай бұрын
hi, WOW - yes, that is amazing! #bonus
@procurementzen
@procurementzen 8 ай бұрын
awesome
@turystycznytester3569
@turystycznytester3569 9 ай бұрын
hi, interesting lessons (I am going through to do KNIME cert :) and unrstand more!)... however there is missing input .xlsx (at least I cannot find it, as it's not embedded in the knime hub workflow)
@procurementzen
@procurementzen 9 ай бұрын
thank you for your comment and the feedback. You need to import the whole "package" as linked in the video description including the "data folder". This contains the source files. Hope that helps.
@turystycznytester3569
@turystycznytester3569 9 ай бұрын
missed the "lesson 25 data types / datesdata" folder, thanks @@procurementzen
@whitepanda95
@whitepanda95 9 ай бұрын
Thank you.
@procurementzen
@procurementzen 3 ай бұрын
more than welcome, hope I could share a bit of knowledge 😀
@designmethodya9674
@designmethodya9674 10 ай бұрын
Thank you so much, i have just a question, i have csv file that contain titles and authors , the most titles are in Arabic, but sometimes i face some latin or romanized titles like this ( Min Dīwān Al-Siyāsah ) , i want to let knime translate cells that contains this kind of romanized or latin characters. Thank you again for Bringing our Minds, Mustafa from Morocco.
@procurementzen
@procurementzen 10 ай бұрын
Thank you for the comment. There are some shared components that utilize Google Translate but I have never used them. Maybe you could ask in the forums
@designmethodya9674
@designmethodya9674 10 ай бұрын
@procurementzen Thank you Again 😊
@phildanley7285
@phildanley7285 10 ай бұрын
Great video as always, Phil. I knew that I was overcomplicating my formula and you fixed my issue when you highlighted CURRENT_COLUMN at the top of the node page. Thank you sir, and have a Merry Christmas!
@procurementzen
@procurementzen 10 ай бұрын
Thanks a lot again for the kind words, Phil. Glad you like it. One thing I recently discovered (actually here in this interesting forums post: forum.knime.com/t/rolling-column-calculation/75922/13) is that you could also use "if" functions within Math Formula Nodes.