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

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

LINQ-Get Only Columns without where

Help Something Else

kumar.varun2 (Varun Kumar) June 8, 2021, 2:03pm 2

this should solve your problem

otherwise you can use

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

Topic		Replies	Views
Trying to select only two columns from datatable without any condition but the above query taking all the columns from the datatable kindly help in linq query Help activities	12	6443	June 28, 2019
How to skip columns using LINQ? Something Else linq	5	5017	June 7, 2021
LINQ query to filter datatable using list and select only specific columns Activities excel , activities , question	6	7139	November 26, 2021
Select required columns from datatable Help	4	2218	November 6, 2018
LINQ: Remove row only if specific column is empty Studio studio , question , activities_panel	6	312	August 27, 2023

Most Active Users - Yesterday
Anil_G
ashokkarale
Ajay_Mishra
Gautham_Pattabiraman
BHUSHAN_NAGAONKAR1
vrdabberu
ABHIMANYU_THITE1
lrtetala
samantha_shah
shyamala_shyamu
More details...

LINQ-Get Only Columns without where

Related Topics