Name need to fill in the column of the excel

[jais1609 (Jeyasankar S)]

Hello,

I have data table named as DT. I want to add a name in the last column of the datatable and need to write a specific name as per DT rows. For an example if DT rows has 100 row i need to write a name as “Excel” 100 times in last column of the DT table.

[vinay_reddy]

Hi, use for each row loop
For each row of DT
Now inside for each row body
Use for each loop
For each of DT.columns
Now inside for each loop body
Use if condition as
If
DT.columns.indexof(item.tostring) = DT.columns.count-1
Then
Use assign activity
Assign
DT.columns(item.tostring) = “Excel”