I have this csv file data but i want to change in only which column start with (c-), this column last row cell data replace in first row cell

image

try this

read the data to datatable using Read CSV

use for each loop to iterate through columns
in condition give dt.Columns and argument as system.data.datacolumn

use an if condition to check column name starts with (c-) by currentItem.ColumnName.StartsWith("c-")

use assign activity in then side
left side - dt.rows(0)(currentItem.ColumnName)
rightside - dt.Rows(dt.rowcount-1)((currentItem.ColumnName))

here dt is your datatable got from csv

Hope this helps

Thanks Lakshmi

1 Like

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