create new column in information steward based on condition

Hi All,

i want to add a new column in information steward view but i want to put a condition per below example

if the result column is having 'missing' the new column should be filled with Missing country if the result column is populated then it should be kept blank

Material plant Result New column 132 3210 Missing Missing country 3330 3210 Poplulated