How to copy the datatable with the string value


#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