I am trying to loop through a DT and write data into a newly created column.
- 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
- I then add a new col to the data table called DirectorID
- 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
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.