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
Solved! Go to Solution.
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
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?