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 A | Column B | Result |
Adam K. | Adam | Adam K. |
Daniel S. | Daniel | Daniel S. |
Peter M. | Peter | Peter M. |
| Martin | Martin |
| Anna | Anna |
| Emily | Emily |
How can this be achieved in Anaplan please?
Thanks a lot,
Richard