hi goodday, what is the sql query used in the assign activity to group data in Excel by a specific value in a column?
Try with this,
From a In table _ Group a By Key = a.artnr Into Group _ Where Group.Count() > 1 Select artnr = Key, numbersCount = Group.Count()
hi sir, i want to group data in an excel file based on a value in a column. suppose that value in the column is same for three other rows. so grouping by the value will show only the three rows.