Yet another great video from Anders. These videos are nice and clear. He also goes over the content numerous times so that you get to see how it is done. After watching quite a few of the videos I can pre-empt the exact way that Anders is going to do it and also know the correct "coding". A sign of a great video and teacher that the content has sunk in and not one of those presentation videos where you are left guessing how to do it. Keep up the great work Anders !!!!!
@andersjensenorg2 жыл бұрын
Hey Craig, thanks a lot for all your nice messages 😍
@gaadas2 жыл бұрын
With this video you just cleared a path for my Kaizen from a pitfall. Thank you!
@andersjensenorg2 жыл бұрын
You're very welcome, Gediminas Balčius - your support helps me a lot 😍
@anatolek72 жыл бұрын
Always enjoy and learn from your videos!
@andersjensenorg2 жыл бұрын
Thanks a ton, Tony - I will be more active from now and going forth (full time doing this now) 🙂
@sojolhamid63563 жыл бұрын
This video is very good, easy & specific to understand the lookup activity using in UiPath. Thanks for sharing.
@andersjensenorg2 жыл бұрын
Hey Sojol Hamid Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders
@BGE92 Жыл бұрын
Thanks for the video. Really amazing. So easy to understand.
@andersjensenorg Жыл бұрын
Thanks a ton, কাকতালীয় 🤩 Have a great day. You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders
@larryding76182 жыл бұрын
Anders, need more UiPath videos....Plz.
@andersjensenorg2 жыл бұрын
Thanks a lot, Larry - I'll do my best 🤩
@gattuakhil23193 жыл бұрын
good concept and neat and clean explanation.....keep up the good work Anders😊
@andersjensenorg3 жыл бұрын
Hey Gattu. Thanks a lot 🙂🙏 If you have any ideas to new topics, feel free to write/reach out. Have a great day. Kind regards, Anders
@gattuakhil23193 жыл бұрын
@@andersjensenorg Hi Anders, Could you please make a short video on set transaction progress activity which we use while dealing with queues...thank you
@hedayat73 жыл бұрын
Great tutorial. It's really helpful. Thanks
@andersjensenorg2 жыл бұрын
You're very welcome, Hedayat Seven - your support helps me a lot 😍
@kienna1113 жыл бұрын
Thanks for your great tutorial!
@andersjensenorg3 жыл бұрын
Hey Trung. Thanks for the nice comment :) Kind regards, Anders
@pncrmpz18513 жыл бұрын
THANK YOU!
@andersjensenorg2 жыл бұрын
You're welcome! 😍
@imjustintan3 жыл бұрын
Solid video. Thank you very much (:
@andersjensenorg3 жыл бұрын
Hey Justin, thanks a lot :) Kind regards, Anders
@davidbjorkqvist35043 жыл бұрын
Thanks!
@andersjensenorg2 жыл бұрын
You're very welcome, David Björkqvist - your support helps me a lot 😍
@imexaztrading1012 жыл бұрын
Hi great videos. How can we take Excel data get it on a weblink and search for it on web and get result back in excel
@andersjensenorg2 жыл бұрын
kzbin.info/www/bejne/jIS3hGCOnJZ8f6M 🙂
@tmadhukrishna44963 жыл бұрын
Hi Anders, I have excel contains 1000 rows . Two columns Name, ID. Now I need to check string 'Madhu' in Name column and update value at ID column. Could you provide me solutions..
@andersjensenorg3 жыл бұрын
Hey T Madhu, sure. Read the excel into a DataTable. For Each Row on it. IF row.item("Name").ToString = "Madhu" and then in then you find an Assign where row.item("ID") = "updatedValue". Let me know, if that solved it? 😊
@ashwina.k56023 жыл бұрын
Hi Anders great video as always! I have few doubts regarding excel, is there a way to add macros to an xlsx file with UiPath? Imagine I have a VBA code stored in a textfile on my desktop, and I wish to convert that into a macro and install it inside of a ExcelWorkbook.xlsx, is it something UiPath is capable of? Also, imagine we have a macro enabled workbook, and I wish to retrieve a list of the macros present inside of it, is this possible?
@andersjensenorg3 жыл бұрын
Hey hsa ok. Thank you for your ongoing kikd words 🙂🙏 Yes for sure, since it's possible for a human. Just replicate that process. The same goes for question 2, can it be done, then yes UiPath can solve it for you. Have a great day, Anders
@rushhh99322 жыл бұрын
Great video! How can i loop from another excel workbook? Cos yours is from same excel workbook with multiple sheets
@andersjensenorg2 жыл бұрын
Thanks a lot, Rushh. Same. You just need to read the other book/sheet into a DT 🙂 Kind regards, Anders
@borislavdancetovic5083 жыл бұрын
Hi Andres, I have a question. You have a Excel with IDs (A1:A5 )which when you use Read Range with For Each Row, that it opens a Page in Browser. In that page I use Data Scraping to get the data as Extracted Data Table. Is it possible to write Extracted Data Table in rows in Excel, for example from B1:F1, depending how many data you have in Extracted Data Table. If not, is it at least possible to write Extracted Date Table in a single cell? I read somewhere that VB.Join should do the trick, but I was unsuccessful in doing this. If you have a advice what I could do here, I'll really appreciate it. Kind regards
@andersjensenorg3 жыл бұрын
Hey Borislav. Great question. You can use an Output DataTable to get your DT as a string and then Write Cell to get that string where you want. Did that help? Kind regards, Anders
@borislavdancetovic5083 жыл бұрын
@@andersjensenorg Hey Andres. Your advice really helped me. With Output data Table I was able to write the result in a single cell. Added a counter so he would add +1 in B cell. It's a shame that Uipath doesn't write the result in the same Excel sheet, so I had to create a copy. Now I have to figure out why doesn't Excel split in column Function work, to split the the one cell in multiple :)
@alonsochaves42303 жыл бұрын
Is there another way to lookup values? I'm working with a large amount of data and this method takes a lot of time executing I believe due to the loop.
@andersjensenorg2 жыл бұрын
Hey Alonso Chaves Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders
@ugurkgs3 жыл бұрын
all your videos are tutorial from each other.
@andersjensenorg3 жыл бұрын
Hey Ugur. Thanks a ton :) Let me know, if you have any questions and feel free to join the Facebook group and/or the Discord. Links are in the description of the video. Have a great day. Kind regards, Anders
@ManasRacin3 жыл бұрын
Hi Anders. The course material is not accessible.
@andersjensenorg3 жыл бұрын
Hey Man. Sorry, my bad. I've fixed it 🙂 Kind regards, Anders
@stevee63053 жыл бұрын
Great video Anders, I'm trying to adapt it so it captures the result of the VLookup to a variable and then uses that value to search on a website. But is there a way that if a particular Element (Element exists) doesen't exist, it then goes back to the Lookup and then searches the next available column. So with my info it has the following: Product Code 1 Code 2 Code 3 Code 4 Case SAM012 SAM013 SAM014 Memory 32GB_SAM 64GB_SAM Screws M2_TORX M4_TORX M5_TORX M6_TORX The VLookup works perfectly and using predefined variables it will find M2_TORX from Column called 'Code 1' - it then takes this value and puts it into Amazon to see if it exists. But if the element does not exists, I want to do is for to search the next column and if it doesn't have the required element it then goes to Code 3...and if the element does exist, this loop terminates
@andersjensenorg2 жыл бұрын
Hey Steve E Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders
@stevee63052 жыл бұрын
@@andersjensenorg thank you Anders, just incase anyone has the same issue this is how I did it: 1) reads from Excel file 2) looks up codes from the respective colums using a 'lookup data table' 3) using a series of IF statements it trys the first value...if it doesent find it then ELSE is the next data table value Hopefully this may help someone 😎
@sundaramkadambavana23643 жыл бұрын
What is the version of studio x used in the tutorial?
@andersjensenorg3 жыл бұрын
Hey Sundaram. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 26th of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
@manjumolsunny25383 жыл бұрын
Hi Anders..Could you please help me to solve the below activity? Read given excel contains 4 columns. member name, age, amount and status Read excel and group all the rows with status as completed Group all rows with status as error Create two tabs in the same sheet as error and completed write the above group of rows to corresponding tabs and save the excel
@andersjensenorg3 жыл бұрын
Hey Manjumol. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
@balafbd743 жыл бұрын
@@andersjensenorg Congratulations Andres!! Hope you are having good time with your new born!!
@christievthomas35312 жыл бұрын
The name Lookup is a bit confusing here I guess, here it means a simple Search/Find. and we already have vlookup between sheets 👍
@andersjensenorg2 жыл бұрын
Hey Christie. For sure and I will make a video around the Excel activities, but to work specific with Excel i still think that the DT activities are the best. Thanks for your feedback !
@camilotics3 жыл бұрын
Thanks good videos. The software is not that much practical.
@andersjensenorg2 жыл бұрын
Hey Camilo R Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders
@rajagopalv71773 жыл бұрын
Hi Anders, my requirement is 1 Lakh record with both excel sheet lookup.. If we use for each row it will take more time.. Any other method.. Please let me know
@andersjensenorg3 жыл бұрын
Hey Rajagopal Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders
@majkimk103 жыл бұрын
What does it mean "gv" ?
@andersjensenorg3 жыл бұрын
Hey Michal. GenericValue, but you can type whatever you want :) Kind regards, Anders
@andersjensenorg3 жыл бұрын
Thanks a lot for all your support and kind words around the UiPath MVP process 😍 Check my best UiPath course (The Beginners Course 2021): kzbin.info/www/bejne/qaGYi6p8gMubY5I 🙂