LINQ-Get Only Columns without where

[KarthikBallary]

Hi

I have 4 columns say column1, column2, column3, column4. what is the linq query to get only col1 and col3. No where condition clause

Regards
Karthik

[kumar.varun2 (Varun Kumar)]

this should solve your problem

How to skip columns using LINQ?

not mandatory removing the last column we can do: filterdatatable activity -col settings - remove - index: dtData.Columns.Count - 1 Working with DataTableVar.DefaultView.toTable(False, arrColSet) arrColSet can be done by DataTableVar.Columns.Cast(Of DataColumn).Select(Function (x) x.ColumnName.Except({“Col1”,“Col4”,“Col34”}).toArray

otherwise you can use

datatable.AsEnumerable.Select(function (x) {x(0), x(2)}).ToList

[KarthikBallary]

can send query syantax than method syantax

[kumar.varun2 (Varun Kumar)]

(from row in inputDT select {row(0), row(2)}).ToList

[KarthikBallary]

if I want it as a data table

[kumar.varun2 (Varun Kumar)]

(from row in inputDT select outputDT.Rows.Add({row(0), row(2)})).Copytodatatable

[NIVED_NAMBIAR (NIVED N)]

Hi @KarthikBallary
another way of acheveing this is by using below assign activity

suppose u had stored ur excel in dt1

then use below assign activity

dt2 = dt1.DefaultView.ToTable(False,{“col1”,“col3”})

then dt2 will only contains col1 and col3

Regards,
Nived N
Happy Automation