Something like "group by" to get rid of duplicated rows?

PrevContributor

Hi, if I refer to a list and receive duplicated rows - is there any way to get rid of them by export or in a module itself? Example: List: Account  SalesOrg    Segment xx              BCS           Commercial xx              ISS             Commercial  xx              HPSD         Commercial yy              BCS           Commercial In my module I want only the below based on above table: Account   Segment xx           Commercial yy           Commercial Is it possible? Thank you in advance for your answer, Dorota

simon_ritchie

Hi Dorota,

if I refer to a list and receive duplicated rows - is there any way to get rid of them by export or in a module itself?

Have you created 3 lists? Account, Sales Org, Segment
Have you loaded data into a module that uses the 3 lists?

Some suggestions:

Create another module with just the Account & Segment list and use a [Sum: ] function to pull the data in.
Generally we explain it as similar to SUMIF in excel, but if you have a Database background you could think of it like Anaplan's eqivalent of a SQL Sum with "Group By" clause.
https://community.anaplan.com/anapedia/calculation-functions/sum

Theres also Max, Min, FirstNonBlank, LastNonBlank functions.
https://community.anaplan.com/anapedia/calculation-functions/max
https://community.anaplan.com/anapedia/calculation-functions/min

If you just want to filter what you are seeing you could think about using the Rank functions.
https://community.anaplan.com/anapedia/calculation-functions/rank
e.g. see attached screenshot. I used the rank function, then you could add a filter to just show you the lines with a Rank of 1. Save this as a view and use the view for your exports.

If you can provide some screenshots of your model (lists, module blueprints etc) maybe I could be a bit more helpful.

Kind regards,
Simon

PrevContributor

Nice - the one with rank! Thank you.