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

Ajaykumar08ns
Ajaykumar08ns
in Modeling

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

image.png

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.

Answers

  • derektslim
    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

Categories