To perform sum if column data is matched

[supermanPunch (Arpan)]

@nithya ,

This seems like a Group By case, Could you try with the below Expression using an Assign Activity :

OutputDT = (From d In DT.AsEnumerable
Group d By k=d("Wage Type Text").toString.trim, l=d("Associate Name").toString.trim Into grp=Group
Where grp.Count > 1
Let sumValue = grp.Sum(Function(x)CDbl(x("Amount").ToString))
Let ra = grp.First.ItemArray.Take(grp.First.ItemArray.Count-1).Append(sumValue).ToArray
Select OutputDT.LoadDataRow(ra,False)).CopyToDataTable

Here DT is your input data from the Excel sheet and OutputDT is the Clone of the Input datatable.

Cloning of the OutputDT could be done in the below way :

OutputDT = DT.Clone

This needs to be done before using the above Expression.

For handling errors related to direct CopyToDatatable, you could check the below post :

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…

Let us know if you are not able to get the Expected Output.