How to filter a column before copying data from one excel to other excel sheet

[praveenM1 (ChatBot)]

I need to copy 4 columns data from one excel to other excel but for one column in first excel, i need values which starts from “SE” and “PE” only to copy other excel, please find below screenshots and suggest me where to keep filter table?

[lakshman (Ganta lakshman)]

@praveenM1

Try below select query to filter DataTable.

                 filterDT = inputDT.Select("ColumnName Like 'SE%' OR ColumnName Like 'PE%'").CopyToDataTable

And then use Write Range activity and pass this Datatable to write into excel file.