Forum Discussion
Solved
Column Creation
Hi,
I want to create a new column, which should show the manager value. Sharing my expected column,
| Associate | Manager | Client | Expected column |
| a | 1 | b | 2 |
| b | 2 | b | 2 |
| c | 3 | c | 3 |
| d | 3 | d | 3 |
| e | 4 | f | 2 |
| f | 2 | f | 2 |
| g | 1 | g | 1 |
| h | 4 | h | 4 |
| i | 2 | x | NA/Null |
| j | 1 | y | NA/Null |
| k | 4 | z | NA/Null |
As per above result in 1st row the new client is 'b' who is under manager '2'. So as per this the value of new column should become '2' but is showing the same value of manger as '1'.
The other condition should be if there is new value in client column then it should not print any value(NA/Null) in new column.
But what i am getting is,
| Associate | Manager | Client | Resul column |
| a | 1 | b | 1 |
| b | 2 | b | 2 |
| c | 3 | c | 3 |
| d | 3 | d | 3 |
| e | 4 | f | 4 |
| f | 2 | f | 2 |
| g | 1 | g | 1 |
| h | 4 | h | 4 |
| i | 2 | x | 2 |
| j | 1 | y | 1 |
| k | 4 | z | 4 |
Please help and advice what to do in such cases?
