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 :
image

OutPut :

Xmal format :

Sample : Phyomt.zip (27.3 KB)

Regards
Balamurugan.S

2 Likes

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.