Clear Data Table value

[flashdrive07 (Pete)]

How to clear data table ?
Set variable (tablename) to empty/clear?

[Krishna_Raj]

@flashdrive07

Unable to Clear Data Table using Clear Data Table Activity

Hi, ClearDataTable activity removes data in all rows, however keeps schema of DataTable such as datacolumn. If you want to remove reference to all the information from dt1, can you try to use the following expression using Assign activity? dt1 = Nothing Regards,

check this reference

Clear datatable and get Null value

If you want to delete whole data in DataTable variable ( data and headers ) then just create a new instance of it like: YourDT = New System.Data.DataTable - it will create new empty instance of DT

[lrtetala (Lakshman Reddy)]

Hi @flashdrive07

Dt.Clone()

Regards,

[mkankatala (Mahesh Kankatala)]

Hi @flashdrive07

You can use the Clear datatable activity.

Hope it helps!!

[flashdrive07 (Pete)]

I want to retain the headers, and clear all the rows

[flashdrive07 (Pete)]

clear data table activity is not available in Studio X

[lrtetala (Lakshman Reddy)]

@flashdrive07

Try this

It will clear all the rows except Column Headers

Dt.Clone()

Regards,

[mkankatala (Mahesh Kankatala)]

Okay, then try to do it with expression… @flashdrive07

Do you want to clear all the data with headers you can use the below expression then it make it new,

- Assign -> DT = New Data.DataTable()

Check the below image by using above expression,

If you want to clear the rows and keep the header use the below expression,

- Assign -> DT = DT.Clone()

Check the below image by using above expression,

Hope you understand!!