Writing into a new col (spreadsheet or data table)

Help
1

Hi all,

I am trying to loop through a DT and write data into a newly created column.

  1. I use table data scraping to obtain data that looks like this

Column-3 Column-4 Action Summary
Appointment Pending David Trump (Tump-D) as Director
Appointment Pending Griffiths (GRIFFITH-O_1) as Director

  1. I then add a new col to the data table called DirectorID
  2. then loop through DT and use RegEx to find the text between ( )

However I cant figure out how to write my newly created DirectorID into the column for the right row

2

@barryrodick

You can write into Datatable as below

Use ForEach Row activity → create a variable in Index

Use Assign Activity
DT.Rows(index).Item("ColumnName").Tostring = "Text you need to set"

For Reference you can check below post

Mark as solution if this helps

Thanks

3

Thank you!

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.