Removing duplicates based on columns Solution No:-11 | uipath | 2024

Removing duplicates based on columns Solution No:-11 | uipath | 2024

Forum Question URL:- https://forum.uipath.com/t/remove-duplicates-from-one-column-based-on-a-different-column-keeping-the-original/710144/5

Linq:-DT.AsEnumerable().GroupBy(function(row)$"{row("Games")} {row("Type")}").Select(function(group) group.first()).copytodatatable()

Vb code:-
In_DT.Clone()

Dim uniqueCombinations As New HashSet(Of String)()

Dim distinctRows As New DataTable()
distinctRows.Columns.Add("Games")
distinctRows.Columns.Add("Type")

For Each row As DataRow In In_DT.Rows
Dim games As String = row("Games").ToString
Dim type As String = row("Type").ToString
Dim combination As String = $"{games} {type}"
If uniqueCombinations.Add(combination) Then
distinctRows.Rows.Add(games, type)
End If
Next
Out_Final_DT = distinctRows

Disclaimer:-We want to make it clear that the content on our channel is for educational and informational purposes only. We're passionate about sharing our knowledge with you.
That being said, we encourage you to do your own research and we want you to succeed in your automation journey, and that means being informed and making the best choices for your unique situation.
Thanks for tuning with us, and we can't wait to see what you'll accomplish with UiPath!

If you have any case studies please post on a comment will try to solve..

#techystack | #uipath | #robotics | #rpa | #rpatutorial | #robot | #orchestrator |#uipathtraining | #automation | #rpatools | #education | #robots | #learning #uipathdeveloper #uipathtutorial #uipathorchestrator #rpaChallenge #rpachallenge

Видео Removing duplicates based on columns Solution No:-11 | uipath | 2024 канала Techy Stack