Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Robotic Process Automation with Automation Anywhere

You're reading from   Robotic Process Automation with Automation Anywhere Techniques to fuel business productivity and intelligent automation using RPA

Arrow left icon
Product type Paperback
Published in Nov 2020
Publisher Packt
ISBN-13 9781839215650
Length 554 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Husan Mahey Husan Mahey
Author Profile Icon Husan Mahey
Husan Mahey
Arrow right icon
View More author details
Toc

Table of Contents (20) Chapters Close

Preface 1. Chapter 1: About Automation Anywhere 2. Chapter 2: Installing Automation Anywhere FREE CHAPTER 3. Chapter 3: Overview of Automation Anywhere Control Room 4. Chapter 4: Overview of the Automation Anywhere Development Interface 5. Chapter 5: Building Your First Bot 6. Chapter 6: Introducing Variables in A2019 7. Chapter 7: Interacting with Applications 8. Chapter 8: String Manipulation and List Variables 9. Chapter 9: Working with Conditional Logic, Loops, and the Filesystem 10. Chapter 10: Working with XML Files 11. Chapter 11: Automating Excel 12. Chapter 12: Automation Using Word 13. Chapter 13: Working with Emails 14. Chapter 14: Working with PDF Files 15. Chapter 15: Working with Databases 16. Chapter 16: Building Modular Bots and Sub-Tasks 17. Chapter 17: Running External Scripts 18. Chapter 18: Managing Errors 19. Other Books You May Enjoy

Appending records to a CSV file

We often need to add records or even logs to a CSV file. In this scenario, we will be writing the calculated results to a CSV file. Each row that we calculated will be a separate row in the output CSV file.

Your first bot has already been able to perform the following tasks:

  1. Create a CSV file.
  2. Read records from a CSV file.
  3. Perform calculations for each row in the CSV file.

We have all the information that needs to be added to the output file. Before we actually add this, we will need to convert the numMonthly variable to a string. This is because we cannot output a numeric value as a string to the output CSV file.

To convert this variable and add the record to our output CSV file, perform the following steps:

  1. Drag the Number: To string action just below line 15, ensuring it is within the Loop action on line 7.
  2. Set the following properties for the String: Assign action on line 16:

    Enter a number: $numMonthly$

    Enter...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €18.99/month. Cancel anytime