OTBI analytic: Populate a value in a column based on another column
In my OTBI analysis I want to have column formula where I check if an employee have any value in column A.
If a value in present in column A for an emoloyee, I want to check what value are present in column B for the same row.
Then I want for the same employee populate a value in a new column C for all the rows having the same value in column B. Even if they dont have any value in Column A.
For example if I have follwing