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
Tagged:
0
Best Answer
-
Hi Dorota,
Have you created 3 lists? Account, Sales Org, Segmentif 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 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,
Simon1
Answers
-
Nice - the one with rank! Thank you.0