Not able to select the first element

[Ritika_Singh]

Hi All,

I am using the below query to select the first element but it is not working correctly . Please can anyone help me with this . The query is -
(From d In DT.AsEnumerable
Group d By k=d(“Reinsurance/Treaty Name Code”).toString.Trim Into grp=Group
Select grp.First()).CopyToDataTable

[Ritika_Singh]

Hi @Yoichi
Any help from your end would be really appreciated.

[pravin_calvin (pravin kumar)]

Hi @Ritika_Singh

Check with the below expression!

** dt.AsEnumerable().GroupBy(Function(i) i.Field(Of String)(“Columnwithduplicatevalues”)).Select(Function(g) g.First).CopyToDataTable**

All about Datatable - UiPath

Hi All, Datatable - variable type is the most commonly used variable type by all UiPath users And it’s been the most often asked queries in forum especially on its manipulation So I would like to have this post as a repository for those who are looking for expressions related to Datatable Let’s go one by one keeping dt as name of datatable variable 1. Get number of rows in a datatable dt dt.Rows.Count (output - int32 type) 2. Get number of columns in a datatable dt dt.Columns.Count (outp…

Regards

[Ritika_Singh]

Not working

[pravin_calvin (pravin kumar)]

Hi @Ritika_Singh

Can we have the screen shots of Inputs and Expected Output?

Regards