Filtering Data Table Duplicates based on a column value

[nvora]

Hello everyone,

I am trying to build a logic to filter data table which is as below.

It should look for Duplicate codes only if the type is “1A” and “1B” and filter them.

The output should be as below:

Let me know if there is a better way to do this apart from nesting through the data table.

Cheers!

[ppr (Peter Preuss)]

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…