If you get an error, remember to set the Authentication to None otherwise you'll get an error (doh!)
@StevenGonzálezManzanares6 күн бұрын
Thanks!! How can i do that for "shared drives"? not just for sheets in "my unit"
@eustasskitty6 күн бұрын
Nice video! Can you teach us how to create a App like in alteryx?
@eustasskitty15 күн бұрын
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!
@eustasskitty22 күн бұрын
Thank you! String manipulation the beeeeest
@rdy4trvl22 күн бұрын
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.
@tosinlitics94921 күн бұрын
@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.
@rdy4trvl21 күн бұрын
@@tosinlitics949 If it works, put it on KZbin!
@lawrencew824327 күн бұрын
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?
@tosinlitics94926 күн бұрын
@@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Ай бұрын
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Ай бұрын
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Ай бұрын
Hello, In the Excel reader node, go to the advanced tab and check the box that says, "Append file path column".
@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Ай бұрын
@@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Ай бұрын
nice。china
@linlin-c1x5kАй бұрын
china ,video is nice!
@odukoyaadewale7556Ай бұрын
Thank youu very muchhhh
@torpedoe1936Ай бұрын
Tosin !!! My Nigerian sister, thanx a million for this easy-to-follow tutorial for Knime beginners.
@rizwanrafeek60212 ай бұрын
Can you do a video visualization And filtering option knime web
@tosinlitics949Ай бұрын
Hello, I do not understand your request. Can you clarify?
@QuocAnhPham-luir103 ай бұрын
My data on the chart shows 3e+11. How can I display it as 300,000,000,000?
@DharshiniMurali-w6e3 ай бұрын
How to set it in knime
@william_ITSOVER3 ай бұрын
wtf
@NsovoWillMashaba3 ай бұрын
Thank you, thank you… great course ❤
@ragingcamel4 ай бұрын
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.
@jazelda895 ай бұрын
does this work if the files have different headers?
@tosinlitics9495 ай бұрын
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".
@imuhtalhakhan5 ай бұрын
Hey, I didn't find any comment for the ongoing workflow to keep the conversation history.
@tosinlitics9495 ай бұрын
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.
@imuhtalhakhan5 ай бұрын
@tosinlitics949 If I want to have a conversation over the given data file, then which node will be helpful in the workflow?
@tosinlitics9495 ай бұрын
@@imuhtalhakhan I go over this here: kzbin.info/www/bejne/n5KtZqCraLmFoqMsi=w-_EcY2JElqPSQHw
@imuhtalhakhan5 ай бұрын
@@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
@tosinlitics9495 ай бұрын
@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.
@ParissaAhmadi5 ай бұрын
Thanks a lot for the perfect description
@tosinlitics9495 ай бұрын
@@ParissaAhmadi You're welcome!
@angelmolinalaguna5 ай бұрын
Amazing 🤩
@victorrichardi5 ай бұрын
thank you so much, this course is amazing!
@victorrichardi5 ай бұрын
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!
@sadoderek62276 ай бұрын
Thank you👍
@domahes6 ай бұрын
this is exactly what a beginner needs - thanks a lot!
@tosinlitics9496 ай бұрын
@@domahes You're welcome!
@domahes6 ай бұрын
thank you!
@BarryB-16 ай бұрын
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!
@tosinlitics9496 ай бұрын
@BarryB-1 Glad you found it helpful!
@henrycovil26296 ай бұрын
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.
@tosinlitics9496 ай бұрын
@@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.
@VaibhavShewale6 ай бұрын
shifting from excel to ai seems harsh for the channel
@tosinlitics9496 ай бұрын
@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.
@VaibhavShewale6 ай бұрын
@@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.Gutzmann7 ай бұрын
When Mozart showed KNIME for the first time to the Kaiser, the Kaiser said: "Too many nodes!" 😉
@tosinlitics9497 ай бұрын
🤣
@jackgaleras7 ай бұрын
Thank you, where can we download the flows you show us?
@tosinlitics9497 ай бұрын
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.
@tosinlitics9496 ай бұрын
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
@muhammadyahyaayyas78457 ай бұрын
thanks 😍
@myungpark7 ай бұрын
wish i found your video 2 hours ago.. Would've gone home from work on time. :)
@madhusudhan53847 ай бұрын
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.
@Jeweunni6 ай бұрын
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
@Pai28 ай бұрын
great video, thank. Can you share the workflow for making the conservation workflow (take previous output as new input). That will be cool.
@tosinlitics9497 ай бұрын
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.
@tosinlitics9495 ай бұрын
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
@googleaccount72528 ай бұрын
Hi, I sent you an email, for some reason my comment here keeps getting deleted.
@googleaccount72528 ай бұрын
Hey, How can I contact you regarding some Knime work.
@googleaccount72528 ай бұрын
@@tosinlitics949 ok emailed you 😊😊
@googleaccount72528 ай бұрын
@@tosinlitics949 Hey, I emailed you. Did you have time to check it?
@bullockspain8 ай бұрын
you saved me a lot
@Griffindor219 ай бұрын
The rule based row filter functions like an SQL statement?
@Sweet_and_spicy1239 ай бұрын
The best channel to learn Knime. I love the way you pack so much information in under 5 minutes for each lesson.
@ISK_VAGR9 ай бұрын
You are my new Hero...!
@tosinlitics9499 ай бұрын
Wow! Thank you!
@Griffindor219 ай бұрын
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.
@tosinlitics9499 ай бұрын
Yes, you can use the replace function to do this.
@701anm9 ай бұрын
Very good of explanation and presentation
@carolina101310 ай бұрын
You're amazing girl. Thank you so much <3
@hakandurgut10 ай бұрын
Great tutorial, thanks, but the background music was a bit distractive
@tosinlitics94910 ай бұрын
Thanks for the feedback!
@AlexaEllis-t7c10 ай бұрын
what to do, if your csv reader returns a error that line has too many data elements
@tosinlitics94910 ай бұрын
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.
@herzbertrattensack393311 ай бұрын
Perfect👍! Thank you 🙏.
@LuizPerciliano_7811 ай бұрын
ótimo vídeo, vai me ajudar em um problema aqui. Obrigado.