Hi,how to duplicate rows with ignorecase?
I like to tell you that one liner does not help forum guys understand an issue.
You must describe in well manner.
I request you to express problem.
Hi, I want get right side data from left
Thanks for screenshot.
You can use Read range activity to read an excel.
- Take Read Range activity and provide path, sheet. it will be stored in datatable variable
- Take write range activity, provide same sheet name, range starts from E1,
have you any idea to how to duplicate left side data with ignorecase to get right side data?
give a try on:
Left side: dtCleansed | Datatype: Datatable
(From d in YourDataTableVar.AsEnumerable
Group d by k1=d(“city”)toString.Trim.ToUpper, k2=d(“ammount”).toString into grp=Group
Kindly note: Cross check the column names on spellings and ensure that the LINQ statement is using the names as in your real data
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.