Top RPA Practical Coding Interview Questions | UiPath coding interview | Episode 6

This is the sixth episode of the entire series, kindly let me know if you liked this video which will help me design the next video with a better approach.
Also put the questions which were asked to you in comments section so that we can help others.
Thank you so much for watching!
Happy Automation.

[@santoshmore210]

Every time Nisarg gives a new information...appreciate your work bhau

[@vijayalakshmiboya9288]

Really enjoying your videos ..Good content and u always come up with interesting things. Keep going . Expecting more from you. Next videos please cover exception scenarios, Assets and Queues. Most of the interviews these three are hot topics. Thank You once again.

[@dhachanamurthydhachanamurt8447]

Very useful...please do post more uipath interview questions

[@praveentomar1212]

extremely useful video ...keep it up Nisarg n well done.

[@nisargkadam]

Thank you so much Praveen 👍🏻

[@chitramanala3842]

Many thanks for your efforts

[@nisargkadam]

Thank you Chitra for the feedback.
If you have any questions in mind you can put it in chat for other subscribers.

[@vijayadaaram]

Hello Nisarg! When I was doing the hands-on for the first question, excel as DB, I am getting an error as "Run command: ERROR [HY000] [Microsoft][ODBC Excel Driver] Operation must use an updateable query." Please help

[@vijayalakshmiboya9288]

Awesome explaination Nisarg. Really nice explaination of RE Framework. I got one question in interview that Queue consists of 5 items but the bot should process only first item and rest of the items the bot shouldnt process. All items will be there in the queue but only first item should be processed by Queue. How can we do this?

[@shaiknajeer1019]

Hello keerthana,
As you said it look like a linear process
We can make it by taking if condition in GetTransaction State and get the queue item when Transaction_number is 1 else assign Transaction _item to Nothing
Hope this information is useful to you...

[@vijayalakshmiboya9288]

@@shaiknajeer1019 got it Thanks

[@TRYHARD_NICK]

Hello I am nikhil from Maharashtra you make a video on a uipath studio give all the information in that video and if anyone is learning uipath studio tell me and this video is very important thank you

[@fancyboys454]

Is there any calls for RPA
now.

[@yashmahale3721]

Where can I get interview questions and answers and some interviews study material

[@nandhukrishna]

Hi , I am facing one problem while doing this ,when I run the update query it is returning the number of Affected rows count correctly but the data is not getting changed in the excel.Did anyone faced the same problem what might be the reason .?Thank you.

[@amitkhyade5029]

You need to check while you are configuring, just check that Read only parameter is disabled.

[@ashwinghosalkar8307]

Hi Nisarg, one of the questions from the interviewer was suppose I am having an excel with columns as id, name, address, email
How do i fetch all details passing a particular id say 10. Can u suggest?

[@nisargkadam]

Noted for next video.

[@ashwinghosalkar8307]

Thank you!

[@theaffiliater3629]

How do I swap var1 to var2 without external VAR or loop

[@nisargkadam]

Two variables A and B
A = A+B
B = A-B
A = A-B

[@prashantgabhane4726]

Nisarg - Instead of deleting the set transaction flowchart we can create an excel and store the transaction status just like queue, and if we delete the how the retry mechanism will work which is the main part of RE

[@nisargkadam]

Yes we can I just did this to quickly make it compatible for an online interview where just the expectation is to switch transaction item.

[@prashantgabhane4726]

@@nisargkadam Got it, Thank you for your effort, I saw your every video from this series and it helped a lot to crack the interviews.. waiting for the next one on the data table and string manipulation questions.

[@nisargkadam]

@@prashantgabhane4726 thanks for the inputs Prashant, I will make sure to focuse next one on datatable and string manipulation.
Would you like it theoretically or practical?

[@prashantgabhane4726]

@@nisargkadam On Practical, Nowadays we need a strong hand-on on string manipulation for coding rounds, they are asking questions related to the string and data table manipulation.

[@nisargkadam]

@@prashantgabhane4726 sure I’ll try to cover as much as possible in that.

[@shaiknajeer1019]

Hi Nisarg
Well explanation , I just obsessed with your all concepts that you have made
I have been asked a question by interviewer that is
How will you extract dynamic tables from a pdf file
i.e the tables are not static and there could be a text between the tables and sometimes a table is spanning into two or three pages
I heard a solution for this
We can solve these kind of table extractions through partial HTML and assigning to variable of webcontrol datatype
I don't have clarity on that
Please make a video on that
Please please please

[@komalvalagadde1571]

Hi Nisarg, Can you please solve this question? The question is you have a excel with 2 columns namely Name and marks. Build a bot to remove duplicate Names from the excel. If names are duplicate then compare their marks and whose marks are highest keep that row and remove another row. Please provide solution to this question.

[@YoYoKhatriSingh]

Best and easiest option would be to convert the excel into DB and use sql command " "Select Name,MAX(Marks) from [Sheet2$] group by Name" " which will give output as new datatable

[@YoYoKhatriSingh]

If you find any other way ...please let me know !!

[@YoYoKhatriSingh]

Bro Another and easiest way is to first sort the excel data on basis of Marks column and then use Range.RemoveDuplicate function on Name column by invoking a vba code in excel open scope