Advanced Debugging in KNIME
2:48
Saving your Vector Store in KNIME
4:32
Concatenate Columns in KNIME
3:30
SumIF/CountIF in KNIME
7:06
Жыл бұрын
Handling Missing Data in KNIME
5:59
Пікірлер
@feenx30
@feenx30 3 күн бұрын
If you get an error, remember to set the Authentication to None otherwise you'll get an error (doh!)
@StevenGonzálezManzanares
@StevenGonzálezManzanares 6 күн бұрын
Thanks!! How can i do that for "shared drives"? not just for sheets in "my unit"
@eustasskitty
@eustasskitty 6 күн бұрын
Nice video! Can you teach us how to create a App like in alteryx?
@eustasskitty
@eustasskitty 15 күн бұрын
Nice video! If possible, create a video showing how to transform a lot files (inside a folder) xlsx to csv/csv to xls/xlsb to csv. Like a macro in Alteryx Thank you!
@eustasskitty
@eustasskitty 22 күн бұрын
Thank you! String manipulation the beeeeest
@rdy4trvl
@rdy4trvl 22 күн бұрын
Very powerful. It would be nice to allow it to access data behind paywalls (with a sign-in and PW). Wonder if Deep Research could track its own performance where it picks stocks.
@tosinlitics949
@tosinlitics949 21 күн бұрын
@rdy4trvl A sign-in functionality would be a game changer! I'm actually planning to see if Claude's automation tools can perform research behind a paywall with the user sign-in.
@rdy4trvl
@rdy4trvl 21 күн бұрын
@@tosinlitics949 If it works, put it on KZbin!
@lawrencew8243
@lawrencew8243 27 күн бұрын
Have you built classification model with string and numerical data and does it perform any differently? Like is it better to use only numeric or only string?
@tosinlitics949
@tosinlitics949 26 күн бұрын
@@lawrencew8243 Hello! I don't use Alteryx anymore, but I'd think it should be able to handle cases with both string and numeric input variables.
@sajithjames4692
@sajithjames4692 Ай бұрын
Thanks for yor videos, really appreciate your insights - though i'm still trying to understand LLMs a bit better. I do have a question for you, with all the workflows you're creating - do you face issues with your harddrive space? I've created some workflows and it's eating my c: drive space & it's causing memory issues. Have had any similar issues and if so how did you resolve them? Reset and/or delete old WFs?
@anneellylira2711
@anneellylira2711 Ай бұрын
In Alteryx, when we insert data into the canvas (input data), in the options, we have option 5 "output file name as field", I always choose "full path", when I consolidate many databases, I like to know which folder it came from and what the name of the Excel sheet is. How do I do this in KNIME? Thank you.
@tosinlitics949
@tosinlitics949 Ай бұрын
Hello, In the Excel reader node, go to the advanced tab and check the box that says, "Append file path column".
@anneellylira2711
@anneellylira2711 Ай бұрын
@tosinlitics949 Hello, I can't see the sheets of Excel. Just the name of Excel. What I see: C:\x\Consolidation\2021\Related.xlsx What I want: C:\x\Consolidation\2021\Related.xlsx|||`Sheet1$` Can you help me? Ty
@tosinlitics949
@tosinlitics949 Ай бұрын
@@anneellylira2711 I made a video to demonstrate how to extract both the file path and sheet name. You can use a string manipulation node to join these columns together if you like. kzbin.info/www/bejne/rJOlmmWCj7OXqbM
@linlin-c1x5k
@linlin-c1x5k Ай бұрын
nice。china
@linlin-c1x5k
@linlin-c1x5k Ай бұрын
china ,video is nice!
@odukoyaadewale7556
@odukoyaadewale7556 Ай бұрын
Thank youu very muchhhh
@torpedoe1936
@torpedoe1936 Ай бұрын
Tosin !!! My Nigerian sister, thanx a million for this easy-to-follow tutorial for Knime beginners.
@rizwanrafeek6021
@rizwanrafeek6021 2 ай бұрын
Can you do a video visualization And filtering option knime web
@tosinlitics949
@tosinlitics949 Ай бұрын
Hello, I do not understand your request. Can you clarify?
@QuocAnhPham-luir10
@QuocAnhPham-luir10 3 ай бұрын
My data on the chart shows 3e+11. How can I display it as 300,000,000,000?
@DharshiniMurali-w6e
@DharshiniMurali-w6e 3 ай бұрын
How to set it in knime
@william_ITSOVER
@william_ITSOVER 3 ай бұрын
wtf
@NsovoWillMashaba
@NsovoWillMashaba 3 ай бұрын
Thank you, thank you… great course ❤
@ragingcamel
@ragingcamel 4 ай бұрын
Fantastic tutorial! Still trying to get my head around converting multiple columns with strings into integers. In my columns I have (among others): Purpose of Credit: cars, mobile phones, home electronics, .... (around 4 options here) Status of existing credit: approved, negative, below x, above y, ... (around 6 options here) Trying to Would it be enough just to define one expression with toInt under string manipulation (multi column)? Thanks before.
@jazelda89
@jazelda89 5 ай бұрын
does this work if the files have different headers?
@tosinlitics949
@tosinlitics949 5 ай бұрын
Yes, you can achieve this by unchecking the "use column values in row" option under the settings tab for Data Area ---> Column Names. In advanced setting tab you can also set the option of "When schema in files has changed" to "Use new schema". Also in this tab, under the "Data Area", "Column Names" section, select either "Use Excel column names", or "Enumerate columns".
@imuhtalhakhan
@imuhtalhakhan 5 ай бұрын
Hey, I didn't find any comment for the ongoing workflow to keep the conversation history.
@tosinlitics949
@tosinlitics949 5 ай бұрын
Here is the full workflow: hub.knime.com/tosinlitics/spaces/Public/Using%20KNIME%20LLM%20Nodes%20for%20Text%20Generation%20and%20Chat%20based%20Information%20Retrieval%20(RAG)~mNF3XYHJwlW9Urk4/current-state The OpenAI ChatApp component from KNIME lets you have a conversation with the model.
@imuhtalhakhan
@imuhtalhakhan 5 ай бұрын
@tosinlitics949 If I want to have a conversation over the given data file, then which node will be helpful in the workflow?
@tosinlitics949
@tosinlitics949 5 ай бұрын
@@imuhtalhakhan I go over this here: kzbin.info/www/bejne/n5KtZqCraLmFoqMsi=w-_EcY2JElqPSQHw
@imuhtalhakhan
@imuhtalhakhan 5 ай бұрын
@@tosinlitics949 hey, I couldn't understand when the workflow changed after 1.19 minutes to this huge one and its quite confusing that which method connects with which node like, we need to dig deeper for that. I would be very happy if you can break the workflow methods into two different files. Thank you
@tosinlitics949
@tosinlitics949 5 ай бұрын
@imuhtalhakhan Did you watch all the videos in the series? I built the workflow step by step throughout the series. The component that lets you chat with your document already comes prebuilt, so I just put it in my workflow.
@ParissaAhmadi
@ParissaAhmadi 5 ай бұрын
Thanks a lot for the perfect description
@tosinlitics949
@tosinlitics949 5 ай бұрын
@@ParissaAhmadi You're welcome!
@angelmolinalaguna
@angelmolinalaguna 5 ай бұрын
Amazing 🤩
@victorrichardi
@victorrichardi 5 ай бұрын
thank you so much, this course is amazing!
@victorrichardi
@victorrichardi 5 ай бұрын
wow, thanks so much for the videos, I'm a IT student and your videos are A M A Z I N G ! thank you so much for the work!
@sadoderek6227
@sadoderek6227 6 ай бұрын
Thank you👍
@domahes
@domahes 6 ай бұрын
this is exactly what a beginner needs - thanks a lot!
@tosinlitics949
@tosinlitics949 6 ай бұрын
@@domahes You're welcome!
@domahes
@domahes 6 ай бұрын
thank you!
@BarryB-1
@BarryB-1 6 ай бұрын
Thanks for the very helpful and interesting introduction to using KNIME and OpenAI! For each step, I paused the video and replicated what you were doing. It worked great!
@tosinlitics949
@tosinlitics949 6 ай бұрын
@BarryB-1 Glad you found it helpful!
@henrycovil2629
@henrycovil2629 6 ай бұрын
Yes, it's a cool site, one of the methods you can use is to simply tell the AI ​​to simply do it better after each time it displays the result. And there is only a small drawback and that is the fact that it does not provide you with the code.
@tosinlitics949
@tosinlitics949 6 ай бұрын
@@henrycovil2629 I'll try this tip next time. Thanks! Yes, it would be awesome if they provided the code. My hunch for this service is that they want to collect all the good ideas for their own benefit. There has to be a catch for it being free, considering the site has to pay for all those models users get to use.
@VaibhavShewale
@VaibhavShewale 6 ай бұрын
shifting from excel to ai seems harsh for the channel
@tosinlitics949
@tosinlitics949 6 ай бұрын
@VaibhavShewale I am confused by your comment as my channel has never been a channel focused on Excel. My channel focuses on Data Science, as I am a Data Scientist. AI falls very well in this topic.
@VaibhavShewale
@VaibhavShewale 6 ай бұрын
@@tosinlitics949 well I looked on ya channel earlier videos were related to excel and you got decent views but as you shifted to ai and other things the views drop down
@Pit.Gutzmann
@Pit.Gutzmann 7 ай бұрын
When Mozart showed KNIME for the first time to the Kaiser, the Kaiser said: "Too many nodes!" 😉
@tosinlitics949
@tosinlitics949 7 ай бұрын
🤣
@jackgaleras
@jackgaleras 7 ай бұрын
Thank you, where can we download the flows you show us?
@tosinlitics949
@tosinlitics949 7 ай бұрын
I just filmed the final video in this series which I will upload shortly. Over the next couple of days, I will clean up the workflow and share it. I will be sure to ping you once it is available.
@tosinlitics949
@tosinlitics949 6 ай бұрын
Here you go! hub.knime.com/tosinlitics/spaces/Public/Using%20KNIME%20LLM%20Nodes%20for%20Text%20Generation%20and%20Chat%20based%20Information%20Retrieval%20(RAG)~mNF3XYHJwlW9Urk4/current-state
@muhammadyahyaayyas7845
@muhammadyahyaayyas7845 7 ай бұрын
thanks 😍
@myungpark
@myungpark 7 ай бұрын
wish i found your video 2 hours ago.. Would've gone home from work on time. :)
@madhusudhan5384
@madhusudhan5384 7 ай бұрын
Thanks for this session. I have learnt how to enter expression on rule engine. However i have doubt i want convert language Arabic to English with the below expression $Translator Value$ = "Arabic" => "English" TRUE => "English" but this is not working , not converting. could you pleas help me with the correct expression to perform this.
@Jeweunni
@Jeweunni 6 ай бұрын
hello if the default value is English, i think it should go like this: $Translator Value$ = "Arabic" => "English" TRUE => $Translator Value$ This means that you are changing all the "Arabic" to "English", and the rest remains the same. So if it was English, it will still be English, if it was example French, it will still be French. If you also want to change French to English, you would need to add another line to change that. Hope this helps
@Pai2
@Pai2 8 ай бұрын
great video, thank. Can you share the workflow for making the conservation workflow (take previous output as new input). That will be cool.
@tosinlitics949
@tosinlitics949 7 ай бұрын
I will soon. I just wrapped up this series with the final video, so I will clean up the workflow and upload it within a few days.
@tosinlitics949
@tosinlitics949 5 ай бұрын
Here is the workflow: hub.knime.com/tosinlitics/spaces/Public/Using%20KNIME%20LLM%20Nodes%20for%20Text%20Generation%20and%20Chat%20based%20Information%20Retrieval%20(RAG)~mNF3XYHJwlW9Urk4/current-state
@googleaccount7252
@googleaccount7252 8 ай бұрын
Hi, I sent you an email, for some reason my comment here keeps getting deleted.
@googleaccount7252
@googleaccount7252 8 ай бұрын
Hey, How can I contact you regarding some Knime work.
@googleaccount7252
@googleaccount7252 8 ай бұрын
@@tosinlitics949 ok emailed you 😊😊
@googleaccount7252
@googleaccount7252 8 ай бұрын
@@tosinlitics949 Hey, I emailed you. Did you have time to check it?
@bullockspain
@bullockspain 8 ай бұрын
you saved me a lot
@Griffindor21
@Griffindor21 9 ай бұрын
The rule based row filter functions like an SQL statement?
@Sweet_and_spicy123
@Sweet_and_spicy123 9 ай бұрын
The best channel to learn Knime. I love the way you pack so much information in under 5 minutes for each lesson.
@ISK_VAGR
@ISK_VAGR 9 ай бұрын
You are my new Hero...!
@tosinlitics949
@tosinlitics949 9 ай бұрын
Wow! Thank you!
@Griffindor21
@Griffindor21 9 ай бұрын
Great video! Can you also do it in the Replace command? I wanted to change a 1 to a Yes, and a 0 to a No.
@tosinlitics949
@tosinlitics949 9 ай бұрын
Yes, you can use the replace function to do this.
@701anm
@701anm 9 ай бұрын
Very good of explanation and presentation
@carolina1013
@carolina1013 10 ай бұрын
You're amazing girl. Thank you so much <3
@hakandurgut
@hakandurgut 10 ай бұрын
Great tutorial, thanks, but the background music was a bit distractive
@tosinlitics949
@tosinlitics949 10 ай бұрын
Thanks for the feedback!
@AlexaEllis-t7c
@AlexaEllis-t7c 10 ай бұрын
what to do, if your csv reader returns a error that line has too many data elements
@tosinlitics949
@tosinlitics949 10 ай бұрын
Hello, Without seeing your specific file I cannot recommend an exact solution. In the past when I had this issue I has some successes using the File Reader node and having it auto detect the delimiter.
@herzbertrattensack3933
@herzbertrattensack3933 11 ай бұрын
Perfect👍! Thank you 🙏.
@LuizPerciliano_78
@LuizPerciliano_78 11 ай бұрын
ótimo vídeo, vai me ajudar em um problema aqui. Obrigado.