Linq code to get array of values

Help Studio
, ,
1

CBMSFunction Creation
CBMSFunction Creation952×243 5.59 KB

Expected output:Chief Product Architect1,Mechatronics & Application Engg.1,Powertrain India1,Chief Product Compliance Officer1,Testing India1,Chassis Systems1…in array
condition is i have to get Team description based on condition is function

2

linq_code_array
linq_code_array1460×744 69.8 KB

3

Hi @sathya_auto

Try this

filteredRows = dt.AsEnumerable().Where(Function(row) row.Field(Of String)("ColumnName").Contains("Function"))


valuesArray= filteredRows.Select(Function(row) row.Field(Of String)("ColumnName")).ToArray()
4

In addition to above:

arrValues | String Array =

(From d in dtData.AsEnumerable
Where d("Category").toString.ToUpper.Trim.Equals("FUNCTION")
Select v = d("Team Description").toString.Trim).toArray

As an alternate getting only the Dictinct values:

(From d in dtData.AsEnumerable
Where d("Category").toString.ToUpper.Trim.Equals("FUNCTION")
Select v = d("Team Description").toString.Trim).Distinct().toArray
5

thankyou for response @ppr @lrtetala
But unable to see output

createFunction1
createFunction11394×730 36.9 KB

6

in such case we can do:

  • set a breakpoint at the for each Activity
  • debug and get paused
  • using the debugging panels for further analysis

Statements like dt - inspect the datatable, ChoosenFunctionArray…

Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

Maybe the filtering is leading to an empty result

7

Keep in mind:
grafik

we gave:
grafik

8

thankyou got it @ppr