How to delete the Row Column data without deleting the header

[Gopikrishna_S]

[Gopikrishna_S]

I want to delete the All the data in this Column Without Deleting Header

[Che]

Hi,

As far as I’m aware you will have to update all the headers. If you want to work directly In Excel you can set a For Each Row and set each field as blank. Or you could Delete and Insert a column.
i.e.

or

Kind Regards

[ashwin.ashok ((TheCodingTheory))]

Hi @Gopikrishna_S ,

Could you try this?

Assign →

dt = dt.Clone()

Kind Regards,
Ashwin A.K

[Che]

He wants to keep the rest of the data, just remove data in column L

[ashwin.ashok ((TheCodingTheory))]

Hi @Gopikrishna_S and @Che,

I hope this is what you meant?

If so, then use this inside of an Invoke Code Activity:

Dt_sampleData.AsEnumerable().ToList().ForEach(sub(row) row(str_colName) = "")

DeleteDataFromSingleColumn.xaml (8.3 KB)

Kind Regards,
Ashwin A.K