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 !!!!!
Thanks a lot for all your support and kind words around the UiPath MVP process 😍 Check my best UiPath course (The Beginners Course 2021): ruclips.net/video/sp5ZwFKfh-0/видео.html 🙂
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: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
@@andersjensenorg Hi Anders, Could you please make a short video on set transaction progress activity which we use while dealing with queues...thank you
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..
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? 😊
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
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
@@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 :)
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?
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
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.
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
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
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
@@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 😎
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
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
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
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: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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
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 !
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
Anders, need more UiPath videos....Plz.
Thanks a lot, Larry - I'll do my best 🤩
With this video you just cleared a path for my Kaizen from a pitfall. Thank you!
You're very welcome, Gediminas Balčius - your support helps me a lot 😍
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 !!!!!
Hey Craig, thanks a lot for all your nice messages 😍
Always enjoy and learn from your videos!
Thanks a ton, Tony - I will be more active from now and going forth (full time doing this now) 🙂
Thanks a lot for all your support and kind words around the UiPath MVP process 😍 Check my best UiPath course (The Beginners Course 2021): ruclips.net/video/sp5ZwFKfh-0/видео.html 🙂
Thanks for the video. Really amazing. So easy to understand.
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: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
This video is very good, easy & specific to understand the lookup activity using in UiPath. Thanks for sharing.
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
Great tutorial. It's really helpful. Thanks
You're very welcome, Hedayat Seven - your support helps me a lot 😍
Thanks for your great tutorial!
Hey Trung. Thanks for the nice comment :) Kind regards, Anders
good concept and neat and clean explanation.....keep up the good work Anders😊
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
@@andersjensenorg Hi Anders,
Could you please make a short video on set transaction progress activity which we use while dealing with queues...thank you
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
ruclips.net/video/VSTS-Xg1IIA/видео.html 🙂
Solid video. Thank you very much (:
Hey Justin, thanks a lot :) Kind regards, Anders
Great video! How can i loop from another excel workbook? Cos yours is from same excel workbook with multiple sheets
Thanks a lot, Rushh. Same. You just need to read the other book/sheet into a DT 🙂 Kind regards, Anders
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..
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? 😊
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
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
@@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 :)
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?
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
THANK YOU!
You're welcome! 😍
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.
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
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
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
@@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 😎
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
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
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
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: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
@@andersjensenorg Congratulations Andres!! Hope you are having good time with your new born!!
Thanks!
You're very welcome, David Björkqvist - your support helps me a lot 😍
Hi Anders. The course material is not accessible.
Hey Man. Sorry, my bad. I've fixed it 🙂 Kind regards, Anders
What is the version of studio x used in the tutorial?
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: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
all your videos are tutorial from each other.
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
What does it mean "gv" ?
Hey Michal. GenericValue, but you can type whatever you want :) Kind regards, Anders
The name Lookup is a bit confusing here I guess, here it means a simple Search/Find.
and we already have vlookup between sheets 👍
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 !
Thanks good videos. The software is not that much practical.
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders