Alternative of insert/delete columns activity

Help
1

Hi All,
i used insert/delete columns to delete multiple columns from an excel sheet but it takes more than 30min time because of higher size.

Please suggest any other way to delete columns from an excel sheet which will take less time for the operation.

2

are you trying tp delete columns based on any keyword or how is it like ??

3

@Pradeep_Shiv

delete
delete860×512 10.9 KB

4

properties

5

dataTablename.select("[Column 1] = ‘value’ AND [Column 2] = ‘value’ ").CopyToDataTable

6

did you use Remove Data Column activity and mention your column name there thats it cheers
@sanjib39

7

@Pradeep_Shiv but it takes more time