Clear column content without deleting column

[markosc]

Hi, I need to clear column (for example Column “ID”) data but I don’t want to delete the entire column, only data.

[Manish540 (Manish Shettigar)]

@markosc Check this below link,

How to delete values of a datacolumn of datatable ? - CodeProject

Hope this may help you

[prasath17 (Guru)]

@markosc - please check this post

Filling Up Blank Cloumn-DT

@shrayud - As an alternate if you have more rows and then you want to avoid “For each” - you can try like this…In the “Invoke Code” Activity… dt.AsEnumerable().ToList().ForEach(Sub(row) row(“Test”)= “New”) [image] My Output(I tried to write “New” in my Test Column… [image]

Instead of New …please replace it to space or string.empty.

[markosc]

But the header name is still being written

[prasath17 (Guru)]

@markosc - May be we misunderstood your question …

Do you want to delete the column name alone?

Please show any sample data and the expected output…

[markosc]

I want to clear the whole column data (header and data below) but don’t want to shift columns

I need to delete “ID_1” header too