How to duplicate rows with ignorecase

Help Studio
, , ,
6

@fightblue
give a try on:

Assign activity
Left side: dtCleansed | Datatype: Datatable
Right side:
(From d in YourDataTableVar.AsEnumerable
Group d by k1=d(“city”)toString.Trim.ToUpper, k2=d(“ammount”).toString into grp=Group
Select grp.First()).CopyToDataTable

Kindly note: Cross check the column names on spellings and ensure that the LINQ statement is using the names as in your real data

2 Likes