Using Linq to filter columns to new sheet

[vignesh.maruthappan]

is it possible to copy two column “package” and “completion” to another sheet using linq?

[lrtetala (Lakshman Reddy)]

Hi @vignesh.maruthappan

Try this

DT1.DefaultView.ToTable(False,{"Package", "Completion"})

Input:

Output:

Cheers!!

[Parvathy (PS Parvathy)]

Hi @vignesh.maruthappan

=> Read Range Workbook
Output-> dt

=> Use below syntax in Assign:
dt = dt.DefaultView.ToTable(False, "Package", "Completion")

=> Write Range Workbook dt to new sheet.

Hope it helps!!

[vignesh.maruthappan]

Thanks @Parvathy if i want to rename the header?

[Dhanamithra_R_G]

Hi @vignesh.maruthappan,
→ Read the data from the Excel sheet into a DataTable using the “Read Range” activity.
->Use LINQ to query the DataTable and select only the columns “package” and “completion”.
->Write the filtered data to another Excel sheet using the “Write Range” activity.

Here DT is output data table from the read range workbook activity

Thank you

[lrtetala (Lakshman Reddy)]

@vignesh.maruthappan

@vignesh.maruthappan

if i want to rename the header?

Try this

DT1.Columns("Package").ColumnName="NewPackageColumnName"
DT1.Columns("Completion").ColumnName="NewCompletionColumnName"

Output:

Cheers!!