To remove the duplicate accounts do the Duplicate values on Column AQ (“Custom Data 12) and for Column BY (“Medical Invoice Number)

Help Forum
1

To remove the duplicate accounts do the Duplicate values on Column AQ (“Custom Data 12) and for Column BY (“Medical Invoice Number)

2

@swethareddy

Can you show what you are trying to achieve using dummy data.

3

@swethareddy,

Can you attach the screenshots or the workflow file? This will help us review the issue and provide the most appropriate solution.

Thanks!

4

Hi @swethareddy

You can use Linq for your need.

refer this :backhand_index_pointing_down:
(From row In dt_Accounts.AsEnumerable() Group row By aq = row(“Custom Data 12”).ToString.Trim, by = row(“Medical Invoice Number”).ToString.Trim Into Group Select Group.First()).ToArray()

Else can you show some data or what you want to remove so that we can help you more clearly.

Cheers