Update status if column has duplicate value

Help Studio
, ,
1

Hi,

I wanted to update the status in an excel file where column has duplicate value in to using linq.

for reference please find attached file.
MBL_Retension.xlsx (9.2 KB)

2

Hi,

Can you also share expected output?

Regards,

3

MBL_Retension.xlsx (9.4 KB)
please find output in status column

4

please help because this issue is extending the time of development

5

HI,

Can you share which column we should check? From the above, I cannot find it.

image
image591Ă—332 6.77 KB

Regards,

6

we have to check “E-id/SR” column

7

HI,

Do you want to input “Duplicated” into the last row of the set of duplicates? The following may help you.

image
image448Ă—691 21.2 KB

Sample
Sample20241023-2.zip (9.6 KB)

Please check result.xlsx

Regards,

8

this will show me an error “Assembly with same name is already loaded”

9

Hi,

For now, can you try to remove project.json then open Main.xaml?

Regards,

10

this is showing invalid document error
can you share the invoke code activity code in this chat.

11

HI,

Hope the following helps you.

dt.AsEnumerable.GroupBy(Function(r) r("E-id/SR").ToString).ToList.ForEach(Sub(g)
If (g.Count>1) Then
    g.Last.Item("Status")="Duplicated"
End If
End Sub
)

image
image1104Ă—554 27.9 KB

Regards,

12

Thanks Bro, its working

1 Like