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.