Get the Duplicate records based on different combination checks in a module

Ajaykumar08ns

I have a scenario where I need to highlight the duplicate records based on different line items combination check. Below is the use case.

I have a module with District and Territory combination code list. Then I have line items to populate Territory, District, Country and Category names. I want now to create a Check (Boolean or Number or any format) which will check if the same territory has been assigned to multiple districts under same country and category.

derektslim

Hi Ajaykumar08ns

Here's one way of going about it.

First, add a line item with Number 1 to your combination list module.

Next, create a module or line item (via subsidiary view) using Territory, District, Country, Category as your dimensions. Formularise it as pointing to the Number 1 line item created earlier, and use SUM to make a count of Territory, District, Country, Category. Use SUM as summary.

Then, in the combination module, create a line item to point back to the SUM line item and use a LOOKUP on Territory, Country, Category to get the count.

Last, do a check on whether the number is >1 using BOOLEAN.

Hope this helps!

Derek Lim