How can I understand this expression in read range activity

[user47 (현호 김)]

There is ‘For Each Row’ activity named ‘For Each - Column Name to Remove from RawDT’ In the file that you can download in below link.

Extract specific columns and values

Check this below workflow, @Sonia_012 Uipath_GetSepcificColumns.xaml (6.4 KB) Hope this may help you

One expression draws me a question.

‘RawDt.Columns.Cast(Of System.Data.DataColumn).Where(Function(s) Not ColumnNameDt.AsEnumerable.Any(Function(c) c(“Column Name”).ToString.Trim.Equals(s.ColumnName.ToString.Trim))).ToArray()’

It’s what it said.

I want to understand this expresstion.

Please tell me what does it mean and how I can practice those expressions.

Thanks for reading.

[Manish540 (Manish Shettigar)]

@user47 This post may help you ,

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…

[ppr (Peter)]

@user47

Please tell me what does it mean and how I can practice those expressions.

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operators Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start # All Operato…

RawDt.Columns.Cast(Of System.Data.DataColumn)

We prepare the processing of the datacolumns for LINQ with the CAST operator/method

.Where(Function(s) Not ColumnNameDt.AsEnumerable.Any(Function(c) c(“Column Name”).ToString.Trim.Equals(s.ColumnName.ToString.Trim))).ToArray()

We do filter with the WHERE operator / method the datacolumns

The filter expression is about: check for the column “ColumnName” in the datatable: ColumnNameDT the values, if there is any value present as the currend looped ColumnName

The looped ColumnName are taken from the DataColumns which we do loop with the cast and from where we take the columnname with s.ColumnName

[user47 (현호 김)]

Thank you for your advice!
You’re a god of UIPath