Drop datatble

[Urvin_Sanghavi]

How to Drop(means delete all table) Datatable Which created using Extract Structured Data Activity.
Note : i have to not clear datatable drop that datatable

Thanks

[jitendra_123 (Jitendra Ughade)]

Hi @Urvin_Sanghavi
We have an activity Clear Datatable to clear all the values of data-table.

[Urvin_Sanghavi]

@jitendra_123 i have to not clear datatable i have to delete datatable.

[AshwinS2 (Ashwin S)]

Hi @Urvin_Sanghavi

Check this

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

or

U can use Dtable.Clone()

Thanks
Ashwin S

[Palaniyappan (Forum Leader)]

@Urvin_Sanghavi

How to Drop(means delete all table) Datatable Which created using Extract Structured Data Activity.

Datatable is a variable and not a value
So if we just ignore using that variable it’s more than enough
Or
We can define that variable within a small scope so that it can’t be used away from it and to set that in the variable panel we got a column named scope where we can set that value
Or
We can simply assign that datatable a value like this using assign activity
Yourdatatablename = New System.Data.Datatable

Hope this would help you
Cheers @Urvin_Sanghavi