Interview Questions | Machine Round | Automate Eagle Financial Website | Automation Anywhere
Вставка
- Опубліковано 12 жов 2024
- In this video we have explained the machine round interview questions being asked at the time of the interview.
In this video we have explained the Eagle Financial Website which will give you the basic idea of automating the Eagle Financial Website and how to use various HTML properties.
If you have any queries regarding this video then raise your queries in the comment section and I will be more than happy to answer all your queries.
URL Link - rpademo.automa...
Well explained 👍
Thank you Aunty ji for your lovely words
thanks for sharing valuable information.
I have one question can I run 2 bots on same machine on same time.
If you have scheduled bots from control room for the same time and if priority of one bot is higher than the other then the one with the most urgent priority will run first and once it completes the first bot then the second bot will run.
@@abhishekarora6136 thanks for quick reply. can you provide like interview preparation for RPA solution/architect/manager level attempt for short duration. Can I communicate via email?
@@siddh8508 sure we can connect
Please share the challenge page link in the description.
Thank You.
Sure Girish will update the link in description by today
Challenge page link has been updated
hi i have one doubt here how you selected this "vCaptured TableData" in variable section ,do we need to create that variable or by default we will get that...please reply Asap
When you will click on create variable in the properties section then it will show it automatically
Hye Abhishek ,in an excel huge data is there from that i just need from column k to AL data later i need to paste that data in other excel K to AL column. currently i just have done opening of both the excel loop through the first excel then paste the data in other excel by set cell .any fastest solution is there for this.
You can use the database approach by creating the connection with both the Excel file and use the select query to retrieve records from the first Excel file and then insert that data using the insert SQL query in the second Excel file
@@abhishekarora6136 set cell is a good approach or not ,
Hi Abhishek with in a single insert query i can fill all the data in second excel file ?is it possible or to feel multiple columns i need multiple insert query
@@helloworld-td2bu in general if data is less then it is a good way but if data is huge then i would say it is not a good approach to use set cell command.
@@helloworld-td2bu use the loop for each row in data table and then use single insert query to insert the data into the Excel file
Can u help with the Japanese domain problem ?
Yes will try to help but before that can you mention the exact scenario
Hello Abhishek can you please say me what's the wrong i am doing so that i am getting that error .as i sended you both the code and error Screen shot in your mail
If you are writing data in second file then you have to create connection string with that output file as well I think that's the issue in your code
@@abhishekarora6136 hey that connection too done just check first 3 line is only about connection and select query for input excel all data retrieval
@@helloworld-td2bu please setup zoom meeting and share me on my WhatsApp number - 9910796342
Hye Abhishek i have a excel sheet in that excel i need to delete data from A4 rows to all the rows present in the excel how can I automate
First of all calculate the total number of rows and then start the loop from 4 to total number of rows you had counted and i side the loop use delete cells option and use specific cell option and pass the column name along with the variable which is given in the loop and select the option delete entire row.
@@abhishekarora6136 calculate the total number of rows then I have to use get multiple cells right and in v11 it will give me excel column variable
I want to delete all the excel files data except header
@@helloworld-td2bu when you open the Excel file using the open command check sheet contains a header checkbox and it will delete all the data except headers. To delete in v11 use get multiple cells and select get all cells as the option and start the loop for each row in Excel dataset and use delete cells option and use the Excel column system variable and pass either the column name or the index of the column
@@abhishekarora6136 hey in my file i have nearly 9 columns and i want to delete all the rows from that except header so how can I choose specific cell option in delete cell command
Hye Abhishek can you please write the select a particular column name from excel by SQL query in automation anywhere v11 ,i am getting syntax error.suppose the colulmn name is address
Can you share the screenshot of the select query which you had written
@@abhishekarora6136 where can I send the screenshot
Sorry I writeen select actually it's insert query issue, insert into[sheet1$] (address) values ($address$)
Hey plz help me here
@@helloworld-td2bu insert into [Sheet1$$] ( Address,ID) values('abc',1) like this you can insert
it's showing 'invalid argument 5 in IF condition'
Could you please check whether how many columns are there in the website because there were 6 columns when I created the video
@@abhishekarora6136 it's the same 6 columns now also
Then it should not show invalid argument 5
Can you share the screenshot of the if condition properties action what you are giving
@@abhishekarora6136 how can I send the screenshot to you
Sir can u help me in some question for advance RPA certification, Please..can't able to cross 70% need 80% for certifications... Can i get ur insta or any social media id.. Please sir🙏
You can connect with me on whatsapp
WhatsApp number - 9910796342