A2019 Automation Anywhere | Master Certification | Use Case-3

 RPA | Master Certification Use Case-3| Automation Anywhere- Part-52

A2019 Master Certification Use Case-3 - In this blog we will discuss regarding the master certification use case-3 wherein we will discuss first the problem statement, then will talk about the pre-requisites and finally we will discuss the steps to build the bot.

So first of all let us discuss the problem statement for the third use case of Master certification which is as follows:-

• Unzip the zipped folder.
• Loop through all the folders present in this unzipped folder.
• Loop through all the files which are present in all the sub folders contained within the folders.
• Check the conditions present in the use case i.e. if year value is equal to 2019, position must be sales, Email column should not be blank, payment method should be credit card, payment status should be paid and price value must be greater than or equal to 50. If the condition is satisfied then write the required data in the output excel file else skip writing the data.
• Close all the applications which were being opened during the development of the bot.
• Copy the output file and rename it as per the naming convention given in the use case i.e. youremailaddress_Bot_3_Output.xlsx.

Note : Do not use data table and database package while developing the bot.

Now we will discuss the steps that are required to develop the third bot use case for the master certification of A2019 Automation Anywhere also known as Automation 360. The steps are as given below:-

• Unzip the zipped folder by dragging and dropping the folder unzip action from the folder package. In the properties section select the zipped folder path and in the destination folder give the destination folder path where you want to unzip the folder.
• Open the output file in which we want to write the output. Drag and drop the open action from the excel advanced package and check the sheet contains header checkbox and provide the session name which will be used further in the process.
• Drag and drop the loop action from the loop package. In the properties section select for each folder in folder package and provide the folder path and assign the output to a string variable data type.
• Drag and drop the loop action from the loop package. In the properties section select for each file in folder from the iterator drop down and provide the path for the files that are present in the folders and assign the output to the variable of the required data type.
• Read all the required column values from each of the excel input file i.e. position, payment method, payment status, email, company name, name, phone number etc. To read the values drag and drop the get single cell command and from the properties section select specific cell and pass the column number and the row number to get the values and store the output in a required variable data type and pass in the same session name that is given as in the open command.
• Check for the required condition if it satisfies the criteria i.e. position must be sales, email should not be blank, price should be greater than or equal to 50, payment method should be credit card and payment status should be paid. If the criteria is met then write the data in the output excel file by dragging and dropping set cell command and passing in the same session name which was used in the open action and if the criteria is not met then skip that record.
• Once all this is done increment the counter variable by 1 by dragging and dropping the increment action from the number package. In the properties section select the source variable and in the increment value field by default the value remains as 1 and will keep it as it is and assign the output to the same counter variable.
• Close all the required open applications used in the building of the bot.
• Rename the file as per the naming convention i.e. youremailaddress_Bot_3_Output.xlsx by dragging and dropping the rename action from the file package.

Here is the code snippet for the steps that we have discussed for the bot development.

With this we have come to the end of our blog where we discussed in detail about the bot-3 use case for the master certification of A2019 Automation Anywhere.

If you have any queries regarding this blog then you can raise your queries in the comment section and I will be more than happy to answer all of your queries. 

The video for the same will be uploaded soon on my YouTube channel.

Please provide your feedback on this blog once you go through this blog as the feedback that you provide really matters the most to me.