Group by duplicate ID and take the highest available amount from other columns

No . You can able use only one column in that activity. I have another activity called “Native Group Aggregation”. But the things is, it doesn’t do the type conversion for the columns . We have to do manually. So to convert the datatable column dataType , we have to use an activity from @Jyotsna from UiPath Labs . I have illustrated an example for you.

Input :

OutPut :

Xmal format :

Sample : (27.3 KB)



Hi, thanks for all the reply and solutions. I still would like to try with Linq statement as i m trying to learn using linq in uipath. Any advice appreciate.