Hello I need to take all the column name as an array in linq expression Here is the sample excel file : Sample.xlsx (5.3 MB)

Hi @Marian_B Try the below expression Use Assign activity RHS - Create an Variable LHS - (from P in PeakE.Columns.Cast(of DataColumn)Select P.ColumnName).ToArray Refer to the thread for more Information about LINQ [image] [HowTo] LINQ (VB.Net) Learning Catalogue Tutorials …

How to taking all the column name as array

Help Activities

THIRU_NANI (NaNi) February 3, 2022, 8:13am 3

Hi @Marian_B

Have a view on this: How to get column names of data table to an array?

Regards,
NaNi

1 Like

Topic		Replies	Views
How to get all values of data column in a datat table Help	10	2161	January 17, 2019
For loop inside Assign Studio question	2	1697	October 13, 2021
Linq for selecting first 3 column values Academic Alliance	1	1628	August 25, 2020
How to get column names of data table to an array? Help	7	24568	March 26, 2019
Select first 25 rows in a datatable Studio studio , question , activities_panel	8	1770	June 5, 2022

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

How to taking all the column name as array

Related Topics