Help me to create linq for following scenario case

Help Studio
, ,
1

In this excel if in column “Role in Company” value comes first time then in last new column “Role” write find and if it comes another time then duplicate
For eg in sheet2 of this excel
challenge.xlsx (16.6 KB)

2

@Swarit_Goyal

image
image1281×693 33.6 KB

(From row In Dt.AsEnumerable()
                            Let role = If(Dt.AsEnumerable().Count(Function(r) r("Role in Company").ToString() = row("Role in Company").ToString()) > 1, "Duplicate", "Find")
                            Select Dt1.Clone().LoadDataRow(row.ItemArray.Concat({role}).ToArray(), False)).CopyToDataTable()
3

Hi,

Can you try the following sample?

image
image491×610 18.7 KB

 dt.AsEnumerable.GroupBy(Function(r) r("Role in Company").ToString).ToList().ForEach( Sub(g)
 g.First().Item("Role")="Find"
 g.Skip(1).ToList.ForEach(Sub(r)
     r.Item("Role")="Duplicate"
 End Sub
 )
End Sub
)

Sample20240208-3.zip (13.3 KB)

Regards,

4

Can you explain me or upload me the xaml

5

@Swarit_Goyal

Sequence.zip (2.2 KB)

1 Like
6

In this can u tell me why u made clone of DT1 and dt (we can add a data column in DT)

7

@Swarit_Goyal

In your Sheet 1 there is no Column name “Role”.So i created a new datatable with Dt means Sheet1 columns plus role column in my new datatable.

I hope you understand

8

If we add a data column like can we take Dt.Clone then

image
image1278×555 35 KB

9

@Swarit_Goyal

Nope this will not work it will raise you a error

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.