Is there any other activity other than Clear data table

Help Studio
, ,
1

Hi,

My clear datatable is not working ,is there is any other activity instead of clear datatable.

2

Hi @Chippy_Kolot ,

In an assign acitvity, dt = dt.clone

Regards,

1 Like
3

Hi @Chippy_Kolot ,

Use assign activity

YourDT = YourDT.Clone

Or
You can re initialize data table.

YourDT = New System.Data.DataTable()

Thanks!

4

Hi @Chippy_Kolot

You can use the Clone() function to remove all the data & retain the table structure like this:

image
image826×230 10.3 KB

You can see dt1_New had the data, but cloning and re-assigning cleared all the data.

Hope this helps,
Best Regards.

5

what is not working, what was implemented?

as an alternate:

dtData = dtData.Clone()

6

Hi @Chippy_Kolot

U can use many ways to Clear the Data in the Datatable

1) use assign activity
dt1=dt1.clone()

image
image1095×310 26.2 KB

  1. Clear datatable activity
    image

Note: The activity must be out side of Foreach row in datatable activity

3) Invoke Method Activity

image
image1212×427 25.4 KB

All things works well

Thanks
VP