Adding a row (or record) of data to Datatable in a loop

Forum|Forum|3 years ago
August 14, 2023
4 replies
2591 views

What I want to do sounds like it should be simple and straightforward, but I can’t think of how to do it in an elegant way.

I am iterating through a list of files and scraping field data from each file within the iteration.

After I scrape all the info from the file, I just want to add the list of values as a row (record) after the last row in the Datatable.

How can I go about this as simply as possible? Or is it possible?

J

J.Logan

Navigator | Tier 3

Unfortunately, working with record objects in AA is anything but elegant. Here is a simple example which you should be able to modify to your needs. First I create an empty record with the headers I need:

I have my table read in from whatever data source:

And I go through and update the columns in my record with the appropriate information, then insert the row into the table:

D

dean.hubak

Navigator | Tier 3

That is the only way, yes...so “elegant”.

B

Bot Dev

Navigator | Tier 3

@dean.hubak

I've built a package with 100+ useful bot commands (actions, properties, variables, etc.) that make AA360 development way less painful, especially when dealing with different datatypes and common use cases.

It even generates record values dynamically! I'm releasing it publicly so the community can benefit from it.

https://github.com/A360-Tools/Toolbox/releases

https://github.com/A360-Tools | https://botstore.automationanywhere.com/vendor/botdev

S

Semih 3318

Pathfinder Advocate | Tier 6

@LoganPrice hi, sorry I might have not fully understood, but you can just add row in datatable package, in last record
its in dataTable package - add row property. If you have the record variable which you want to add as a row, its easy to do
If you have any questions to me, I will do my best

Sign up

Login to the Pathfinder Community