Issue: Combine 2 columns

Options
RichardG
RichardG Member, ALL USERS Posts: 4 New Contributor
in Anaplan Community

Hello all,

 

I am fairly new to Anaplan and I would need help with one task. I have 2 columns and I would need to create additional 3rd column, where the first 2 are combined. The combination should work as follows: look for a string in one column, if you find the string, assign the string, if its blank assign the value from the other column. Both column A and Column B refer to the same names, but the information in Column A is more accurate, so I'd like to use that one if its available.

 

Column AColumn BResult
Adam K.AdamAdam K.
Daniel S.DanielDaniel S.
Peter M.PeterPeter M.
 MartinMartin
 AnnaAnna
 EmilyEmily

 

How can this be achieved in Anaplan please?

 

Thanks a lot,

Richard

Tagged:

Comments

  • RichardG
    RichardG Member, ALL USERS Posts: 4 New Contributor

    Hello @rob_marshall ,

     

    thank you for the solution. In both columns I actually have list members and when trying out your formula error message displays:

    RichardG_0-1608658118059.png

    Any suggestion how to approach this?

     

    Thank you!

     

    Best,

    Richard

     

  • RichardG
    RichardG Member, ALL USERS Posts: 4 New Contributor

    Hi @rob_marshall ,

     

    both column A and B are line items, but the format is list.

     

    RichardG_0-1608671918479.png

    The column A in the example is the line item "final mapping" and the column B would be "Center" which is a list member.

     

    Best,

    Richard

  • RichardG
    RichardG Member, ALL USERS Posts: 4 New Contributor

    @rob_marshall ,

     

    Is it possible to match 2 string values solely on the strings in the field? What you suggested works, however since both are numbered lists, the results are the #ID in the lists. I will need to use this line item further to bring in actuals from different module and I assume, I will not be able to do so with the set of #ID from 2 different numbered lists.

     

    A bit more background: The list used for column B in the example would be #WL_Cus03_BAM list, which contains all the centers where we sell. Our customers are hospitals and sometimes they group together, to get better pricing conditions. The list A in the example would be Centers-Groups within GPO, here some of the centers from list B are already grouped and the rest of the centers where the grouping is not relevant are blank. In another module, I have actuals per center (from list A) and what I need to do is to be able to somehow bring the actuals to list B, where the actuals for the grouped centers is the sum of the centers within the group. 

     

    What I tried to achieve by the exercise in the ADM_06 module (screenshot from previous reply) is, I have there all the centers in one column (Center), then for the centers where grouping is relevant, I have the name of the groups(Final Mapping). The desired result would be to have a column with center names, but where relevant the group name would display for all the centers within that group.

     

    The groups might change and are created directly in the model. Each center has a BAM name, which is also the code, but the groups of centers do not have any code.

     

    Thank you.

    Richard

Categories