Hi bro, I am not able to see ncounter function in Excel basic while setting the value into cell column, please help me

IM getting 404 not found

Yes

"message": "The request was rejected because the URL contained a potentially malicious String \"//\""

Thanks. Good explanation.

How can i Have this version of the free control room version, when i try to do this example the generative recorder it's not available

Builk pkg updation available at conrolroom level or BOT level ?

I got 403 Not Found

How to join your WhatsApp group bro

Nice .....great video on new features of A360

Really good video Ganesh

Is there a way to write data from json to data table in A360 and then write it to excel as output because this is not practical for big data

Good job buddy. It resolved my issue. Thanks!

Percentage of 40/60= ans*100 Right??

Bro can you attach the credentials world vedio link

How abt extracting Table data ??

Can I send the image in bulk as a wishes of festival

-1 is the answer that I got

Unable to find CLIENT. Search Criteria did not match. How to fix this? //*[@class="DayPicker-Month"]/*/*[@class="DayPicker-Week"]/*[@class="DayPicker-Day"][@aria-label="$ExcelRow[2]$"]

When I do the same data is not updating in website

Can you please tell logic to print the numbers in ascending order for example input is 170,45,75,90,802,24,2,66 then output should be 2,24,45,66,75,90,170,802

Hi Bro, Nice video and i have one request How to write a logic in Automation Anywhere A360 to get previous day excluding weekends Example:- If the current date is 30/09/2024 output should be 27/09/2024 Can u please guide how to write a logic on this 😊

Nice video, I request you please make more and descriptive videos on API

thank you so much

Super Explanation

Nicely done Ganesh!

Instead we have direct compare string command in string package

Nice Video. Please post more about Co-pilot

does automation anywhere access information of the user in background processing like credit card details, username ,etc ??

Hi @Ganesh - AI Brahma - Thanks for sharing this learning. I am encountering one issue while trying to implement, when I open 'MakeMyTrip' website it is opening a pop-up window, please let me know how to close the pop-up, I am using only community license and don't have paid license version for A360. Kindly help, thanks.

=@TRANSPOSE(@Input!A1:D4) @ is getting appended to formula. What is the solution.

Thanks for this info. Btw, what is the parameter for Image?

Thank you!

Hi Ganesh, I am not able to find that app password option in my PC. what should i do? is there any other way to get it done.

Nice video~ how to download enterprise version or upgrade community version into enterprise if I have already installed a community version?

thanks brother very helpful

Interview We have multiple PDF files with different formats and want to extract PO Number from pdf file without using IQ Bot or document Automation PO Number position is not fixed. In some pdf po number is like Example 1. P.O. Number: 123555 2. P O Number: 2345 3. P.O Nu mber:3453 Please help me with Question

Thanks Ganesh for your wonderful effort. Those who are done this script, if your excel output is filled with empty rows in between. Here is the reason - We have assigned and increment(counter+1) counter values in inner loop (that means Botsdna website table). Instead, in the outer loop (That means 'Each row in worksheet') before the loop started - assign Counter variable with 1 (because excel having header) and after loop started assign "conter+1 = Counter" to write the data from 2nd row in excel. It works as expected. Reason for empty rows after 5th line and so on: Because if you compare first 5 account numbers in excel sheet with website table it will match (till the Union bank of India - 7541). but the 6th row it is not matching (Indian bank -5174). Hence the counter keeps increment until it finds excel match with next website match that means (ICICI - 1514) So generating empty rows that many times in between. Thanks

Please make a video on Xpath

Hi ganesh , I am looking for RPA training and also need practical practice.

Thanks Ganesh your wonderful effort. Another method : Using only one variable and It will dynamic as well. Step : 1 String reverse the Input string and assign it to Input String Step : 2 Substring (Start from 3 ) and (Length 7) and assign it to Input String Step :3 Again String reverse the Input string and assign it to Input String

Good hands-on exercise for Loops and Assign

Hi Ganesh, I hope this comment will reach you, First of all, we are thankful for your wonderful effort, Please correct my understanding on this 'String reverse without reverse action' logic You said that String variable also starts from Index '0' like other variables List and Table, but it seems String starts from Index as '1' You are decrementing the Counter variable by 1, because of - for the 1st iteration we need to remains the Length as '5' but by the same time counter value is '1'. so, resulting (length(5) - counter(1) = 4) So we will get output as letter 4th position 'I' and as a end result we will receive only I D N I (only 4 character). it should not be the case. Index 1 2 3 4 5 Char I N D I A Into the Iteration - length - counter = to get Starting position for sub string (Iteration #1 5 - 0=5, Iteration #2 5 - 1=4, Iteration #3 5 - 2=3, Iteration #4 5 - 3=2, Iteration #5 5 - 4=1) we are not reaching here Index '0' by the Iteration. So, as a conclusion if the String index start with '0' we don't need to decrement the counter by 1. String index starts with '1'. Please correct me if my understanding is wrong. Because - if we approach this code as String starts with index '0' it leads to confusion.

Json

In the last line (message box) - It is working fine with out using typecase (any to string) since it is 'Any' variable. like Message box $anySum$

Please being videos like this, i am looking for certification this month

Thank you❤ For starters, if you dont have paid OpenAI API & you want free APIs. You can get free API for Google Gemini model. Or You can also get Cohere free API. Both are as capable as OpenAI chatgpt. 😊

Its Very useful for interview. Can you please some more particle question on Excel.

if cell is 1000 or 2000 how can you do it will take time and sometimes not work properly

not like developer thinking its like very bad approach