How to copy the datatable with the string value

Help
1

New Microsoft Excel Worksheet.xlsx (8.8 KB)

i want to copy the datatable which contains (502-2315054) its complete data into the another data table

regards,
hemanth

2

@hemanth_chinna

Try this Query

dt2=(From p In dt.Select
where string.Join(",",p.ItemArray).Contains("502-2315054")
Select p).ToArray.CopyToDataTable

dt is the DataTable variable which you will get by reading the excel sheet
dt2 is the Filtered DataTable

Now use Writerange activity to Write in excel sheet.

Regards,
Mahesh

2 Likes