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

Highlighted
Previous Contributor

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

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

2 REPLIES 2
Highlighted
Certified Master Anaplanner

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

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
Highlighted
Previous Contributor

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

Nice - the one with rank! Thank you.